Excel not calculating properly (bizarre)...

Occasional Contributor

Hello all,


For some reason, when calculating % changes in Excel, the results are incorrect.

This is the first time I have experienced this.


Attached is a screenshot - the example shown gives a result of 3.56%. However, the correct answer should be 3.78%.


Any idea why this is happening?


Many thanks in advance.





3 Replies
best response confirmed by KirkExcel (Occasional Contributor)

Hi @KirkExcel 


No problem here:



I suspect your values in T4 & S4 are not exactly 1.85 and 1.92

Check by increaising the number of decimals

Of course. Thank you so much!
You're welcome & Thanks for providing feedback