Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
=IF(OR(x={2,4,6,8}),"BLUE",IF(OR(x={1,3,5,7}),"YEL LOW",IF
(OR(x={10,12,14,16}),"GREEN"))) where x is the cell containing the values, like: =IF(OR(A1={2,4,6,8}),"BLUE",IF(OR(A1={1,3,5,7}),"Y ELLOW",IF (OR(A1={10,12,14,16}),"GREEN"))) -----Original Message----- I need to create a function that says: If cell x is either 2,4,6,or 8, then type 'blue' in cell y and if cell x is either 1,3,5 or 7, then enter 'yellow' in cell y and if cell x is either 10,12,14,or 16, then enter 'green' in cell y etc.... . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions |