If then question

[Guest]

Column A Column B
A -
VOA C
OA C
VA Y
VO -
VO C

I want a formula which will return a 1 if there is an "A" in column A and is
not "-" in column B nad a zero if both those conditions are not met. So in
the example above, the 2nd, 3rd, and 4th rows would return a 1 and the 1st,
5th, and 6th rows would return a 0.

Help please.

 

[Guest]

Try this:

=IF(OR(ISERROR(FIND("A",A1)),B1="-"),0,1)

HTH,
Elkar

 

[Guest]

in column c:

=IF(AND(ISNUMBER(FIND("A",A2)),B2<>"-"),1,0)

HTH

 

[Guest]

Thanks to both of you for your help.