Forum Discussion

Steven Tomberlin's avatar
Steven Tomberlin
Copper Contributor
Jun 12, 2018

Calculation

Previous versions of Excel allowed me to write the following equation, "=SUM(B5-B4)/B4" now the version I have through Office 365 won't. Any suggestions?

 

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Steven,

     

    what do you me by "won't work"?

    Anyway, SUM() is superfluous.

    (B5-B4)/B4 is sufficient.

    B5/B4-1 is even better.

Resources