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]
[TABLE="class: cms_table, width: 256"]
<tbody>[TR]
[TD="class: cms_table_xl63, width: 64"]A Blank[/TD]
[TD="class: cms_table_xl63, width: 64"]B Blank[/TD]
[TD="class: cms_table_xl63, width: 64"]C Blank[/TD]
[TD="class: cms_table_xl63, width: 64"]Result[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl64, width: 64"]TRUE[/TD]
[TD="class: cms_table_xl64, width: 64"]TRUE[/TD]
[TD="class: cms_table_xl64, width: 64"]TRUE[/TD]
[TD="class: cms_table_xl63, width: 64"]Pass[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl64, width: 64"]TRUE[/TD]
[TD="class: cms_table_xl64, width: 64"]TRUE[/TD]
[TD="class: cms_table_xl64, width: 64"]FALSE[/TD]
[TD="class: cms_table_xl63, width: 64"]Pass[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl64, width: 64"]TRUE[/TD]
[TD="class: cms_table_xl64, width: 64"]FALSE[/TD]
[TD="class: cms_table_xl64, width: 64"]FALSE[/TD]
[TD="class: cms_table_xl63, width: 64"]Pass[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl64, width: 64"]TRUE[/TD]
[TD="class: cms_table_xl64, width: 64"]FALSE[/TD]
[TD="class: cms_table_xl64, width: 64"]TRUE[/TD]
[TD="class: cms_table_xl63, width: 64"]Pass[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl64, width: 64"]FALSE[/TD]
[TD="class: cms_table_xl64, width: 64"]FALSE[/TD]
[TD="class: cms_table_xl64, width: 64"]FALSE[/TD]
[TD="class: cms_table_xl63, width: 64"]Fail[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl64, width: 64"]FALSE[/TD]
[TD="class: cms_table_xl64, width: 64"]FALSE[/TD]
[TD="class: cms_table_xl64, width: 64"]TRUE[/TD]
[TD="class: cms_table_xl63, width: 64"]Pass[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl64, width: 64"]FALSE[/TD]
[TD="class: cms_table_xl64, width: 64"]TRUE[/TD]
[TD="class: cms_table_xl64, width: 64"]FALSE[/TD]
[TD="class: cms_table_xl63, width: 64"]Fail[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: cms_table, width: 256"]
<tbody>[TR]
[TD="class: cms_table_xl64, width: 64"]FALSE[/TD]
[TD="class: cms_table_xl64, width: 64"]TRUE[/TD]
[TD="class: cms_table_xl64, width: 64"]TRUE[/TD]
[TD="class: cms_table_xl63, width: 64"]Fail[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Then try this version:

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