Multiple responses based on value range

[simk]

Hi, basic enough excel user.... I need a cell to return a value based on it's numerical range for 4 different ranges. I've got everything in place to return values now I just need to have the value of that cell to return a result in the other cell. I can use IF function for a range for one value, it's just adding in the extra ranges I'm stuck at.

So:
If cell A1 less than 7 then A2 would be -1
If cell A1 between 14 and 8 then A2 would be -2
If cell A1 between 21 and 15 then A2 would be -3
If cell A1 between 28 and 22 then A2 would be -4
If cell A1 greater than 28 the A2 would be 4+

Hope that makes sense

[Glenn Kennedy]

Hi there. try this:

=IF(A1="","",LOOKUP(A1,{0,8,15,22,29},{-1,-2,-3,-4,"4+"}))

[simk]

Well..... that is TOTALLY not the way I was trying to do it at all lol!

But yes that works thanks, appreciate it

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.