Formula Help Needed!
 

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

Formula Help Needed!
 

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

"pivot table" wrote:

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

Formula Help Needed!
 

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

"pivot table" wrote:

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

Formula Help Needed!
 

Please do not double post!
--
** John C **

"pivot table" wrote:

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