SOLVED

# Excel not calculating properly (bizarre)...

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

Best,

Kirk

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

# Re: Excel not calculating properly (bizarre)...

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

# Re: Excel not calculating properly (bizarre)...

Of course. Thank you so much!

# Re: Excel not calculating properly (bizarre)...

You're welcome & Thanks for providing feedback
1 best response

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

# Re: Excel not calculating properly (bizarre)...

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