View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lost and Looking for Help
 
Posts: n/a
Default If AND Statement

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)