SOLVED

Excel not calculating properly (bizarre)...

Copper 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.

 

Best,

 

Kirk

3 Replies
best response confirmed by KirkExcel (Copper Contributor)
Solution

Hi @KirkExcel 

 

No problem here:

Sample.png

 

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
1 best response

Accepted Solutions
best response confirmed by KirkExcel (Copper Contributor)
Solution

Hi @KirkExcel 

 

No problem here:

Sample.png

 

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

Check by increaising the number of decimals

View solution in original post