IF formula help

Solved/Closed
GF - 22 Jul 2016 à 12:35
 GF - 22 Jul 2016 à 15:10
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 " ".


1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
22 Jul 2016 à 14:03
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!