You can also use boolean conditions like:
=(A11) * 1 - checks one condition
=(A12) * (A1<8) * 1 - both conditions must be true
However, this type of conditioning does not work with text.
A more detailed explanation can be found he
http://www.pdbook.com/index.php/exce...itch_formulas/
----
Regards,
John Mansfield
http://www.pdbook.com
"velopoav" wrote:
Everytime i type that condition into an if statement it doesnt calculate the
number correctly... what am i doing wrong?