jeudi 1 février 2018

What's wrong with my else if statements in spreadsheets

This is what I have tried, I am trying to get it to do two different calculations based on a yes or no answer.

=IF(ISNUMBER(SEARCH("Yes", B2)), (A3*Rules!N9),IF(ISNUMBER(SEARCH("No", B2)), (A3*Rules!N4/100)),

Aucun commentaire:

Enregistrer un commentaire