jubilee101
New Member
- Joined
- Apr 17, 2013
- Messages
- 25
Hi guys,
i'm under pressure to get this done in next 3 hours ao any help would be appreciated.
lets say I have 4 cells ABCD. The text in A can will either say "Pass" or "Fail" depending on the following:
IF (B,C,D = blank ) then A=“Pass”
If B not blank but C,D are Blank, then A=“Fail”
If B is not blank and C is not blank then A=“Pass”
IF( B,C,D not blank, then A=“fail”)
I've tried doing nest IFs & AND and I just can't get it to work
i'm under pressure to get this done in next 3 hours ao any help would be appreciated.
lets say I have 4 cells ABCD. The text in A can will either say "Pass" or "Fail" depending on the following:
IF (B,C,D = blank ) then A=“Pass”
If B not blank but C,D are Blank, then A=“Fail”
If B is not blank and C is not blank then A=“Pass”
IF( B,C,D not blank, then A=“fail”)
I've tried doing nest IFs & AND and I just can't get it to work
Last edited: