This is what I have tried, I am trying to get it to do two different calculations based on a yes or no answer.
yes
no
=IF(ISNUMBER(SEARCH("Yes", B2)), (A3*Rules!N9),IF(ISNUMBER(SEARCH("No", B2)), (A3*Rules!N4/100)),
Aucun commentaire:
Enregistrer un commentaire