Formula Help Needed!

[pivot table]

Example

column a = blank
column b = blank
column c = blank
column d = blank
column e = will ALWAYS have a number

so if there is a number in column e then say yes assuming all other cells
are blank


if there is a number in column e and any other column then say no

this is what I need a formula based on...

 

[Mike H]

Don't multi post it's irritating to those who give their time freely to
answer questions only to find the question answered in another group

 

[Sheeloo]

Use in F1 and copy down

=IF(AND(A1="",B1="",C1="",D1=""),"Yes","No")

This does not check for E1 since you are sure it will always have a value.

You can add that also
=IF(AND(A1="",B1="",C1="",D1="",E1<>""),"Yes","No")

 

[John C]

Please do not double post!