conditional to change number to a range

[vvkelley]

Hi Folks,
I have a column of numbers and want to use a conditional to change it into three ranges: <10, 10-20, and >20. I've searched a bit and have an idea of how to do this but am making a mistake somewhere. I can do =if(a1<10,"<10", if (a1>10 but I can't figure out how to specificy >10 and <20 and have a value returned. I'm making a mistake somewhere in the formatting. Any help is appreciated.

Thanks!

 

[VoG]

Maybe like this

=LOOKUP(A1,{0,10,20},{"<10","10-19",">=20"})

 

[Aladin Akyurek]

Hi Folks,
I have a column of numbers and want to use a conditional to change it into three ranges: <10, 10-20, and >20. I've searched a bit and have an idea of how to do this but am making a mistake somewhere. I can do =if(a1<10,"<10", if (a1>10 but I can't figure out how to specificy >10 and <20 and have a value returned. I'm making a mistake somewhere in the formatting. Any help is appreciated.

Thanks!

B2:

=IF(N(A2)>0,LOOKUP(A2,{0,10,20},{"<10",">=10 & < 20",">=20"}),"")

Does this suffice?

 

[vvkelley]

Thanks very much, both commands work. I apprecaite it.

 

[Aladin Akyurek]

Thanks very much, both commands work. I apprecaite it.

Great. Thanks for providing us feedback.