View Single Post
  #2   Report Post  
Bob Umlas Excel MVP
 
Posts: n/a
Default

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

.