Steven Tomberlin
Jun 12, 2018Copper Contributor
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?
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?
Steven,
what do you me by "won't work"?
Anyway, SUM() is superfluous.
(B5-B4)/B4 is sufficient.
B5/B4-1 is even better.