mardi 21 mars 2017

How to do an If Else in google sheets?

Right now I'm trying to figure out whether a cell contains one of two values, it will then perform an operation which depends on whatever value is in said cell. This is the function I have so far

=IF(ISNUMBER(SEARCH("btc", I2)), (E2*(1+10%)-D2),""), IF((ISNUMBER(SEARCH("pp",I2)),E2-D2,""))

however I found that you cannot do 2 if statements in the same cell. I am not sure where to go from here, thanks for any help.

Aucun commentaire:

Enregistrer un commentaire