IF formula

[Olia]

Hi
Need help.
Need a correct formula
if a=97-100 then b=1,1
if a=85-96,99 then b=1

Thanks in advance

[AliGW]

Try this:

=IF(AND(A1>=85;A1<97);1;IF(AND(A1>=97;A1<=100);1,1;0))

[Pete_UK]

Try this in B1:

=IF(A1>=97;1,1;IF(A1>=85;1;""))

You have not said what you want if a is below 85 - this formula returns a blank.

Hope this helps.

Pete

[Richard Buttrey]

Maybe I'm missing something - (wouldn't be the first time) but you appear to be saying that all the values from 85-100 should result in a 1.
Hence if so, why do you want two if tests?

[Pete_UK]

Richard,

I think the OP uses a comma instead of a decimal point, so 97-100 equates to 1.1 and 85-97 equates to 1.0

Pete