Multiple IF number falls between.....

[tlacloche]

Hello,

in column A i have random numbers.

In colomn B i would like a formula that gives the output:

"small" if the adjacent cell in column A is less than 10
"medium" if its between 10 and 30
"large" if its over 30

thank you

[Jonmo1]

Try

=LOOKUP(A2,{0,10,31},{"small","medium","large"})

[nathansav]

=IF(A1<10,"Less",IF(AND(A1>=10,A1<=30),"Medium","Large"))

[tlacloche]

thanks guys

[Jonmo1]

You're welcome.

[Tony Valko]

Here's another one...

=IF(A2>30,"Large",IF(A2>=10,"Medium","Small"))