EXCEL FORMULA RETURN X IF VALUE IN 4 CELLS HAS VALUE

R

RERAA

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
 
D

David Billigmeier

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

Aladin Akyurek

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

RERAA

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