Excel not calculating properly (bizarre)...

[KirkExcel]

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

[#2 · Accepted solution]

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

[#3]

Of course. Thank you so much!

[#4]

You're welcome & Thanks for providing feedback