Multiple if statement to return single value based on numerous ranges

[mcranda]

I have tried to find help on the internet and through this forum, but can't seen to find a multiple if statement for ranges. Maybe, I am using incorrect terminology. Can someone help me or link me to a similar formula.

I have a column that has a number in it and want column V to return the values underlined below

I need a formula to return the values of:

1-30 range: (U2>0,U2<31)
31-60 range: (U2>30,U2<61)
61-89 range: (U2>60, U2<90)
90+ range: (U2>89)

[Tankstir]

Does this help:
=IF(AND(M7>=1,M7<=30),"1-30",False). M7 = the input value to check, the formula is any other cell.
You can replace False in the formula with a nested if; i.e.
=IF(AND(M7>=1,M7<=30),"1-30",IF(AND(M7>=31,M7<=60),"1-60",FALSE))
and so on. It really depends on what you want your results to look like. Replace "1-30" with whatever value you would like returned, if the criteria are met. Let me know if you have additional info. If this resolves your issue, please label your thread "Resolved". Thx, Tankstir

[oeldere]

Use VLookup for that.

[Neil_]

=CHOOSE(MATCH(U2,{0,30,60,90},1),"1-30 Range","31-60 Range","61-89 Range","90+ Range")

[Tankstir]

I would use Neil's! good one. I'll use it.

[mcranda]

=IF(U2="","",(CHOOSE(MATCH(U2,{0,30,60,90},1),"1-30 Range","31-60 Range","61-89 Range","90+ Range")))

This is what I have so far. Can we add a -# to return At HRC? Thanks

Just curious about another formula. I was looking at using =Lookup(A1,{0,10.01,12.51,15.01},{5%,7%,9%,10%}). Would this have worked too?

[mcranda]

=IF(U2="","",(CHOOSE(MATCH(U2,{-1000,0,30,60,90},1),"At HRC","1-30 Range","31-60 Range","61-89 Range","90+ Range")))

I believe this should do the trick. Thank you

[Tankstir]

RE: your lookup, yes it works too. However, replace 5% with .05, etc. Please mark the this Post as "Resolved".

[Ace_XL]

Try

=LOOKUP(U2,{0,31,61,91},{"1-30 Range","31-60 Range","61-89 Range","90+ Range"})