IF formula help [Solved/Closed]

Ask a question GF - Last answered on Jul 22, 2016 at 03:10 PM by GF
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 " ".

plus moins
GF, Good afternoon.

Try to use:


Is this what you want?
I hope it helps.
Belo Horizonte, Brasil.
Marcílio Lobão
GF- Jul 22, 2016 at 03:10 PM
Awesome!! It worked great! You're the best!

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!