Mar 20 2021 09:04 AM
I'm trying to come up with a formula and wondering if i can get some help?
If a1=1 then d1=15, a1=2 then d1=20, a1=3 them d1=30,a1=4 then d1=40
Mar 20 2021 09:08 AM
SolutionMar 20 2021 09:08 AM
SolutionAs variant in D1
=IFERROR(CHOOSE(A1,15,20,30,40), "wrong index")