lundi 2 août 2021

Excel if statement - if not this or not that - do this

Need some help with this formula:

=if(m3="No","Yes","No"),if(m3="","","")

If m3 = is blank(""), I want this cell to stay blank and ignore the Yes or No first part of the formula. How do I do this?

Any help would be appreciated.

Aucun commentaire:

Enregistrer un commentaire