Formulas

[LizzieC740]

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 🙏🏻:crossed_fingers:. Many thanks in advance. 

[#2 · Accepted solution]

@LizzieC740 Enter this formula in D15:

=E15*5 and press enter.

[#3]

@Riny_van_Eekelen thank you so much, you’ve made it look so easy!!! Much appreciated :smiling_face_with_smiling_eyes: