Forum Discussion

KirkExcel's avatar
KirkExcel
Copper Contributor
Apr 30, 2023

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

  • Lorenzo's avatar
    Lorenzo
    Silver 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

Resources