+ Reply to Thread
Results 1 to 4 of 4

Help needed with Nested If Statements.

  1. #1
    Registered User
    Join Date
    02-06-2016
    Location
    Bristol, England
    MS-Off Ver
    2010
    Posts
    2

    Help needed with Nested If Statements.

    Sorry, title changed.
    Last edited by bikerpaul; 02-06-2016 at 07:12 AM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Simple formula help required

    Please help me here by changing your title to:

    Help needed with Nested If Statements.

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    02-06-2016
    Location
    Bristol, England
    MS-Off Ver
    2010
    Posts
    2

    Re: Simple formula help required

    Thanks. That is halfway there. What about F, the foundation tier. Sometimes I need to change their tier levels and with your formula, which I greatly appreciate, works for higher, or I could change to work for foundation but I would still need to manually change the formulae if the tier changed which makes the whole test for "H" or "F" redundant. Idealy, I would just like to change H or F and the formula recognises the tier and evaluates grade accordingly.

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Help needed with Nested If Statements.

    Bikerpaul, even though you changed your title, your post no longer contains the information that would allow anyone to understand what you need. Neither post #3 or #1 contain enough info to allow someone to know what you need.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Simple Conditional Formating Help Required - If Blank then Red Bold text required
    By thilag in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2014, 12:23 PM
  2. simple Formula required !
    By boltoncalling in forum Excel General
    Replies: 6
    Last Post: 01-11-2012, 09:05 AM
  3. Help required with a simple Loop
    By Pedros in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-27-2006, 08:00 AM
  4. Simple Count formula required
    By mike_vr in forum Excel General
    Replies: 2
    Last Post: 01-23-2006, 11:35 AM
  5. simple validation formula required
    By archeti in forum Excel General
    Replies: 13
    Last Post: 10-27-2005, 06:05 AM
  6. Help required to run simple macro...
    By londonchick in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-22-2005, 03:05 PM
  7. Simple explanation of formula required pls
    By Swn-Y-Mor in forum Excel General
    Replies: 4
    Last Post: 01-14-2005, 08:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1