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