If AND Statement

  • Thread starter Lost and Looking for Help
  • Start date
L

Lost and Looking for Help

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)
 
A

Arvi Laanemets

Hi

When A1=0, then the result is zero anyway, except A2=0 too.
When A1<>0, but A2=0, then dividing retuns an error with checking you
wanted.

Probably you need a formula
=IF(A2=0,0,A1/A2)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


"Lost and Looking for Help"
 
B

Bruno Campanini

"Lost and Looking for Help"
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)
Click to expand...

You must take into account A2=0

=IF(NOT(A2),0,A1/A2)

Bruno
 
Top