mardi 19 avril 2016

Google Sheets: =IF(ISTEXT(SEARCH to return a sum instead of a text answer

=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