=IF(AND(H2<"Graapes",H2<"Oranges"),"Neither",H2)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"jh3016" wrote in message
...
I have a simple question, I believe.
I would like if H2 contains "Grapes", then enter "Grapes" in J2. If H2
contains "Oranges", then enter "Oranges in J2. If H2 does not contain
Grapes
or Oranges, enter "Neither" in J2.
Can someone give me the formula for this?
Thanks in advance.
|