IF formula help [Solved/Closed]

GF - Jul 22, 2016 at 12:35 PM - Latest reply:  GF
- Jul 22, 2016 at 03:10 PM
Hello,
I am needing a formula like this
=IF(OR(B4="apple",B4="Banana",B4="carrot"),"yes","no") but if the cell B4 is blank. I need a blank " ".


See more 

2 replies

Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Jul 22, 2016 at 02:03 PM
0
Helpful
1
GF, Good afternoon.

Try to use:

=IF(B4="","",IF(OR(B4="apple",B4="Banana",B4="carrot"),"yes","no"))

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Awesome!! It worked great! You're the best!