Formula Help Needed!

P

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...
 
M

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
 
S

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")
 
Top