excel 2016 formulas for solving E10=2 then F10=70, E10=3 then F10 =77, E10 =4 then F10=84 etc. +7

1 Reply

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)