Help with a formula (>=, <=; IF statements)

[SChalaev]

Hi guys,

This formula gives me a value of 1 when I want a value 0, can someone explain why that happens?

=IF((AND(D8>=130)),(IF(E8=0,1,E8)),0)

where formula for D8 is =IF(D9=0,"",(ROUND(D9*100/$C8,1))) and let's say that D9 is in fact 0.

If I change the formula for D8 and write it as =IF(D9=0,0,(ROUND(D9*100/$C8,1))), then everything works out fine.

For some reason in the bolded formula (D8>=130) is evaluated ("">=130) as TRUE.... shouldn't it be FALSE because "" = 0 ?

Many thanks,

Stas

[benishiryo]

welcome to the forum, Stas. "" is actually different from the normal blanks we see in an empty cell. "" is a text & a text is regarded to be greater than numbers. on a sidenote, i don't know what's the AND for. without understanding what you need, this will give you the same results:
=IF(D8>=130,IF(E8=0,1,E8),0)

you do need the AND if i were to check for the "" now:
=IF(AND(D8>=130,D8<>""),IF(E8=0,1,E8),0)

[SChalaev]

Thanks for explaining it benishiryo, makes more sense now!