View Single Post
  #2   Report Post  
StinkeyPete
 
Posts: n/a
Default

=IF(H2="Grapes","Grapes",IF(H2="Oranges","Oranges" ,"Neither"))

"jh3016" wrote:

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.