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!
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!