EXCEL FORMULA RETURN X IF VALUE IN 4 CELLS HAS VALUE
 

RETURN A VALUE OF X IF A VALUE IN 4 OTHER CELLS HAS A VALUE. IF ANY CONDITION
MEETS ARGUMENT RETURN X
VALUE IN OTHER CELLS WILL BE MIXED APPHA AND NUMERIC

When you say "Any Condition" I assume you mean "atleast 1 of the conditions."
In that case, assume your 4 conditions are in A1,B1,C1,D1, place this
formula in E1:

IF(OR(A1=<First condition,B1=<Second condition,C1=<third
condition,D1=<fourth condition),"X","")

Anything other than that and you'll need to be more specific.


--
David Billigmeier


"RERAA" wrote:

RETURN A VALUE OF X IF A VALUE IN 4 OTHER CELLS HAS A VALUE. IF ANY CONDITION
MEETS ARGUMENT RETURN X
VALUE IN OTHER CELLS WILL BE MIXED APPHA AND NUMERIC

Do you mean: Whenever any numeric or text value in 4 other cells, say,
B2:E2, then X?

RERAA wrote:
RETURN A VALUE OF X IF A VALUE IN 4 OTHER CELLS HAS A VALUE. IF ANY CONDITION
MEETS ARGUMENT RETURN X
VALUE IN OTHER CELLS WILL BE MIXED APPHA AND NUMERIC

David,
Thank you for the reply. To be more specific if any one of the 4 cells has a
value enter x. if all 4 cells have no value leave cell blank.
the 4 cells in question have other reference formulas in them. will that
make a difference in outcome of this discussion.

"David Billigmeier" wrote:

When you say "Any Condition" I assume you mean "atleast 1 of the conditions."
In that case, assume your 4 conditions are in A1,B1,C1,D1, place this
formula in E1:

IF(OR(A1=<First condition,B1=<Second condition,C1=<third
condition,D1=<fourth condition),"X","")

Anything other than that and you'll need to be more specific.


--
David Billigmeier


"RERAA" wrote:

RETURN A VALUE OF X IF A VALUE IN 4 OTHER CELLS HAS A VALUE. IF ANY CONDITION
MEETS ARGUMENT RETURN X
VALUE IN OTHER CELLS WILL BE MIXED APPHA AND NUMERIC