IF, AND, OR?

[micahthomas]

I'm having trouble with and IF statement.

I have 3 columns, 2 manual entries, and then a calculation.
In my calculation formula, I need an if statement before the calculation.

Here's what I want:

If A2=0 and B2=0, then C2="" (or just empty)
AND if A2=0, **while B2 could be any number** then C2=1

What do I need to do?

Thanks in advance

 

[Jonmo1]

=IF(AND(A2=0,B2=0),"",IF(AND(A2=0,ISNUMBER(B2)),1))

 

[Aladin Akyurek]

=IF(A2,"?",IF(N(B2),1,""))

 

[KWMSeattle]

Does this do what you want?

=IF(AND(A3=0,B3=0),"",IF(AND(A3=0,B3<>0),1,0))

 

[micahthomas]

YES, KWMSeattle you get the prize. Thanks so much. I think the trick is the B3<>0. What does that tell the formula to do? It works like a charm. Thank you!

 

[Jonmo1]

"<>" = "does not equal"