Two different result between a range of values

[gpktm]

Hello everyone

I need a formula to give me the result of "1" between the numbers over 12 and less than 15. And number "2" over 15.

An example: If my cell is...

12 = 0
12.00001 = 1
14.99999 = 1
15 = 2

[FDibbins]

You didnt say what you want to do with numbers <12, so try try this...

=if(and(a1>12,a1<15),1,if(a1>=15,2,0))

[gpktm]

Yes I'm sorry. Any values less than twelve equals to zero.

And thanks for the formula. All worked fine.