If AND Statement
"Lost and Looking for Help"
wrote in message
...
I have a number in Cell A1 and A2 for example.
I want a formula that says, that IF A1 and A2 are both Zero, then to place
a
zero in the the cell, if false divide A1/A2. Here is the formula i used
but
it obviously doesn't work
=IF(A1=0 and A2=0,0,A1/A2)
You must take into account A2=0
=IF(NOT(A2),0,A1/A2)
Bruno
|