lundi 12 juin 2017

Change formula based on cell value excel

I am trying to change the formula of cell B based on the value of cell A. If the value in A is 2, i want the formula to be e^(b*x) and otherwise it should be x^2.

I tried it with an IF-statement:

=IF(G2=2; [D2*EXP(-(L2*E2))];[E2^2])

But it does not work. Also, examples only use IF-statements to display text. So i am wondering if what i would like to do is even possible.

Aucun commentaire:

Enregistrer un commentaire