Results 1 to 4 of 4

Thread: Which function should I use?

  1. #1

    Which function should I use?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello!
    I am trying to figure out what function to use. Here's the situation:

    I have different ranges of values (e.g. 13,000 - 15,000; 15,001 - 17,000; 17,001 - 19,000) that receive different rates depending on which range they fall into, and I'm wondering how to say " if cell A1 value is between 13,000 and 15,000, return with X; if it's between 15,001 and 17,000 give it Y, etc."

    Here's an example to help make it clear what I'm looking for:

    Column 1 Column 2
    13,000 - 15,000 = 60%
    15,001 - 17,000 = 55%
    17,001 - 19,000 = 50%
    19,001 - 21,000 = 45%
    21,001 - 24,000 = 40%

    Cell A = $19,450

    Cell B = 45%

    I'm looking for a formula that will look at Cell A, categorize it into the appropriate range, then give the coordinating rate in Cell B (45% in this example).

    I hope this makes sense! thank you!

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    Cell A1=$19,450, Put the below formula in Cell B1

    =IF(AND(A1>=13000,A1<=15000),"60%",IF(AND(A1>=15001,A1<=17000),"55%",IF(AND(A1>=17001,A1<=19000),"50%",IF(AND(A1>=19001,A1<=21000),"45%",IF(AND(A1>=21001,A1<=24000),"40%")))))

  3. #3
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Another suggestion:

    you can try Lookup Function. plz see the file.
    Attached Files Attached Files

  4. #4
    THANK YOU!!
    This is JUST what I was trying to figure out! I so appreciate you taking the time to help me! This is great! Thanks again!!!

    Quote Originally Posted by sambit View Post
    Hi,
    Cell A1=$19,450, Put the below formula in Cell B1

    =IF(AND(A1>=13000,A1<=15000),"60%",IF(AND(A1>=15001,A1<=17000),"55%",IF(AND(A1>=17001,A1<=19000),"50%",IF(AND(A1>=19001,A1<=21000),"45%",IF(AND(A1>=21001,A1<=24000),"40%")))))

Posting Permissions

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