Forum Discussion
LizzieC740
Sep 08, 2022Copper Contributor
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 up to number 6 equalling 30 as it goes up in 5’s
Grateful for any help please 🙏🏻🤞. Many thanks in advance.
LizzieC740 Enter this formula in D15:
=E15*5 and press enter.
- Riny_van_EekelenPlatinum Contributor
LizzieC740 Enter this formula in D15:
=E15*5 and press enter.
- LizzieC740Copper Contributor
Riny_van_Eekelen thank you so much, you’ve made it look so easy!!! Much appreciated 😊