Forum Discussion
John Waller
Jul 10, 2017Copper Contributor
excel 2016 formulas for solving E10=2 then F10=70, E10=3 then F10 =77, E10 =4 then F10=84 etc. +7
- Detlef_LewinSilver Contributor
Hi John
Some possible solutions:
=56+E10*7 =LOOKUP(E10,{2;3;4},{70;77;84}) =CHOOSE(E10-1,70,77,84) =SWITCH(E10,2,70,3,77,4,84) =IFS(E10=2,70,E10=3,77,E10=4,84)