=IF(ISTEXT(SEARCH("TEXT",A1)), "TRUE","FALSE")
I want to do something similar to this, but not quite and am wondering what formula to use or what language to include in this formula to fix it.
What I want to do is, when I place this formula in B1, if A1 contains the word "text", I want to return a sum of C1+D1. If it does not, I want to return a sum of C1+E1.
How can that be achieved instead of a binary answer?
Aucun commentaire:
Enregistrer un commentaire