if formula

[msaiyad]

Please help in this formula.


A2 = 0 B2= 1

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

result wanted
A2= 0 B2=0 C2 ??? 0
A2= 0 B2=1 C2 ?? 0
A2= 1 B2= 0 c2 ?? 0
A2= 1 B2= 1 c? A2+b2
please help

 

[Weaver]

Try

=IF(AND(A2,B2),2,0)

Assuming A2 and B2 will only ever be 0 or 1

or

=AND(A2,B2)*2

 

[Andrew Poulsom]

Maybe:

=IF(OR(A2=0,B2=0),0,A2+B2)

 

[msaiyad]

thx all of you it's working