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

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

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

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