SOLVED

formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2225033%22%20slang%3D%22en-US%22%3Eformula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2225033%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20come%20up%20with%20a%20formula%20and%20wondering%20if%20i%20can%20get%20some%20help%3F%3CBR%20%2F%3EIf%20a1%3D1%20then%20d1%3D15%2C%20a1%3D2%20then%20d1%3D20%2C%20a1%3D3%20them%20d1%3D30%2Ca1%3D4%20then%20d1%3D40%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2225033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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

3 Replies
best response confirmed by cplrich (New Contributor)
Solution

@cplrich 

As variant in D1

=IFERROR(CHOOSE(A1,15,20,30,40), "wrong index")
that worked thank you!

@cplrich , my pleasure