Excel Logic Query

[Netraider]

I have 5 cells, A1 - A5 for example with or without content. I need A6 to = "Pass" for the following....

A1 = Anything
B1 = Anything
C1 = Empty
D1 = Empty
E1 = Anything

I need A6 to = "Fail" for any other condition.

I have been playing with =If(And for a couple of hours but am having issues around working with either empty cells or cells that aren't empty.

Any hints or tips?

 

[MarillionFan]

=IF(LEN(C1&D1)=0,IF(LEN(A1&B1&E1)>0,"Pass","Fail"),"Fail")

 

[eek]

You need the isblank and and statements

=IF(AND(ISBLANK(A1)=FALSE,ISBLANK(B1)=FALSE,ISBLANK(C1)=TRUE,ISBLANK(D1)=TRUE,ISBLANK(E1)=FALSE),"Pass","Fail")

 

[Netraider]

Many thanks, Eeks formula was easier to use in this situation, but a fantastic fast response as always from the CUK IT Helpdesk.

 

[Contreras]

Late to the party but I would have done:

=IF(AND(NOT(ISBLANK(A1)),NOT(ISBLANK(B1)),ISBLANK(C1),ISBLANK(D1),NOT(ISBLANK(E1))),"Pass","Fail")

or maybe:

=IF(OR(ISBLANK(A1),ISBLANK(B1),NOT(ISBLANK(C1)),NOT(ISBLANK(D1)),ISBLANK(E1)),"Fail","Pass")