+ Reply to Thread
Results 1 to 3 of 3

IF Statement with multiple ranges

  1. #1
    Registered User
    Join Date
    07-09-2008
    Location
    Richmond, VA
    Posts
    5

    Red face IF Statement with multiple ranges

    I need to create an If statement that will give me a percentage based on a range...

    So, if A1 is between 0 and 10 then A2 should be 5%
    If A1 is between 10.01 and 12.50 A2 should be 7%
    If A1 is between 12.51 and 15.00 A2 should be 9%
    If A1 is between 15.01 and higher A2 should be 10%

    I could not find the formula that helped in my searches, so I ask you help .

    Thanks so much

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Try:

    =Lookup(A1,{0,10.01,12.51,15.01},{5%,7%,9%,10%})
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    07-09-2008
    Location
    Richmond, VA
    Posts
    5

    w00t!

    Thank you very much that worked perfectly now I can keep track of my placements this will help greatly THANK YOU for taking the time to spell it out for a newbie.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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