View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bruno Campanini
 
Posts: n/a
Default 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