# Thread: Which function should I use?

1. ## Which function should I use?

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!  Reply With Quote

2. 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%")))))  Reply With Quote

3. Another suggestion:

you can try Lookup Function. plz see the file.  Reply With Quote

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!!! Originally Posted by sambit 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%")))))  Reply With Quote

#### Posting Permissions

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