range

[BigB77]

Hello All,
What formula would I use to accomplish the below.

If A1 is 1.5 to 1.9 bring back 101
If A1 is 2.0 to 2.4 bring back 111
If A1 is 2.5 to 2.9 bring back 121

This goes on for a while.
Can you please help!

 

[Jonmo1]

Try

=LOOKUP(A1,{1.5,2,2.5},{101,111,121})

 

[Scott Huish]

=if(a1>=1.5,101+((int(a1*2)/2)-1.5)*20,"")

 

[Jonmo1]

I was thinking of a similar logic too.
Assuming
0 - 0.4 = 71
0.5 - 0.9 = 81
1 - 1.4 = 91


=71+INT(A1/0.5)*10