Countif Formula

[heleneshere]

Hi Everyone!

Just need some help here on how to count if..
I need a single formula for column C, with the conditions below:
1. two columns have date (A & B), C should be 1.
2. if column A&B is declined, column C should be 0
3. If column A has date and column B is blank, column C should be 1
4. If column A is blank and column B has date, column C should be 1


A2: Feb 11 B2: Feb 12 C2:
A3: Declined 1 B3: Declined 1 C3:
A4: March 4 B4: C4:
A5: B5: March 5 C5:


Thanks in advance..

 

[Bob Phillips]

Try

=IF(A1&B1="DeclinedDeclined",0,IF(OR(AND(ISNUMBER(A1),ISNUMBER(B1)),AND(ISNUMBER(A1),B1=""),AND(A1="",ISNUMBER(B1))),1))