Forum Discussion

LizzieC740's avatar
LizzieC740
Copper Contributor
Sep 08, 2022
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 up to number 6 equalling 30 as it goes up in 5’s

Grateful for any help please 🙏🏻🤞. Many thanks in advance. 

Resources