heleneshere
New member
- Joined
- Jan 7, 2015
- Messages
- 5
- Reaction score
- 0
- Points
- 0
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..
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..