urgent - nested ifs

[jubilee101]

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

 

[jubilee101]

I was off a column in my grid, it is not A, B, C, but rather B, C, D. But I can now see what you are after.
Since there are only two conditions that would return "Fail", let's check for those, and then have anything else return "Pass", i.e.

=IF(OR(AND(B1<>"",C1<>"",D1<>""),AND(B1<>"",D1<>"")),"Fail","Pass")

Sorry i was missing last row of table:

[cod]

A Blank	B Blank	C Blank	Result
TRUE	TRUE	TRUE	Pass
TRUE	TRUE	FALSE	Pass
TRUE	FALSE	FALSE	Pass
TRUE	FALSE	TRUE	Pass
FALSE	FALSE	FALSE	Fail
FALSE	FALSE	TRUE	Pass
FALSE	TRUE	FALSE	Fail

<tbody>
</tbody>

FALSE

TRUE

TRUE

Fail

<tbody>
</tbody>

 

[Joe4]

Then try this version:

=IF(B1="","Pass",IF(AND(B1<>"",C1<>"",D1=""),"Pass","Fail"))