Forum Discussion

John Waller's avatar
John Waller
Copper Contributor
Jul 10, 2017

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

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver 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)

Resources