Is "IF" what I want

[eperry0303]

Hi there, trying to figure out the best way to do this. I've used the "IF" before, but not sure if I can mak that work for this.

Column A is is whole numbers that range from -5 to about 100, and in column B, I want to insert a value 0-9, depending on which range the value of column A falls in. For example:

If column A<0, I want a "0" in column B
If column A is greater than 0 but less than or equal to 11, I want a "1" in column B
If column A is greater than 11 but less than or equal to 20, I want a "2" in column B...

And so on. Can I apply these multiple conditions (I'll have 10) to each cell in column A?

 

[VoG]

Try like this

=LOOKUP(A1,{-10,0,11,21},{0,1,2,3})

 

[Jonmo1]

Are you sure of

If column A<0, I want a "0" in column B
If column A is greater than 0 but less than or equal to 11, I want a "1" in column B
If column A is greater than 11 but less than or equal to 20, I want a "2" in column B...

That doesn't seem consistant...

This will do

If column A<0, I want a "0" in column B
If column A is greater than 0 but less than or equal to 10, I want a "1" in column B
If column A is greater than 10 but less than or equal to 20, I want a "2" in column B...

=MAX(0,ROUNDUP(A1/10,0))

 

[eperry0303]

That looks like it's working, thanks much!