IF function returns FALSE instead of 0

[fernipascual]

Hi:

I am having difficulty with a formula that is returing FALSE when I want it to return 1.

=IF(A2=0,IF(B2=0,0),1)

When a = 0 and b > 0, then FALSE (this should be 1)
When a > 0 and b = 0, then 1 (OK)
When a = 0 and b = 0, then 0 (OK)

I can't figure it out.

Thanks for the help.

 

[Jonmo1]

try

=IF(A2=0,IF(B2=0,0,1),1)

 

[T. Valko]

Hi:

I am having difficulty with a formula that is returing FALSE when I want it to return 1.

=IF(A2=0,IF(B2=0,0),1)

When a = 0 and b > 0, then FALSE (this should be 1)
When a > 0 and b = 0, then 1 (OK)
When a = 0 and b = 0, then 0 (OK)

I can't figure it out.

Thanks for the help.

Try this...

=IF(OR(AND(A2=0,B2>0),AND(A2>0,B2=0)),1,0)

 

[Scott Huish]

Assuming the only condition for 0 is when they are both 0, perhaps:

=OR(A2:B2)+0