Forum Discussion
KirkExcel
Apr 30, 2023Copper Contributor
Excel not calculating properly (bizarre)...
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.
Best,
Kirk
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