New Contributor

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. 

2 Replies
best response confirmed by Hans Vogelaar (MVP)

@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