Forum Discussion
Solved
Formulas
Hi, trying to solve a formula as follows:- if a cell, eg E15 has a 1 entered in it, then cell D15 automates the number 5, then if E15 has a 2 entered in it, the cell D15 changes to 10. And so on ...
LizzieC740 Enter this formula in D15:
=E15*5 and press enter.
LizzieC740 Enter this formula in D15:
=E15*5 and press enter.
Riny_van_Eekelen thank you so much, you’ve made it look so easy!!! Much appreciated 😊
