Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula works in some cells, doesn't in other | New Users to Excel | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Function to look at two cells and return a third | Excel Worksheet Functions | |||
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions |