jeudi 3 mai 2018

If Then Statements In One Excel Cell

I would like to modify the percentage that is being calculated each time the price changes.

For example the equation is =+(E25 * G50)/12, however now I want the calculation to change in the same cell, but this time I want to multiply the figure in cell G51. I tried using an IF statement: IF(E25 >=200000 , E25 * G50)/12, I am probably doing something wrong.

Thanks for any help!

Aucun commentaire:

Enregistrer un commentaire