Forum Discussion

Twopir's avatar
Twopir
Copper Contributor
Oct 12, 2021

Formula getting .01 cent diffrence

in the excel sheet, we are calculating cell +C8-C28 it's getting the 0.1 cent difference

Example 25,000.00-14,809.57 = it should be return 10,190.43 but it is returning 10,190.44

in our excel sheet  25,000.00 in (C8) column and 14,809.57(C28) column

and we are using this formula to get the result +C8-C28

 

please help thanks 

excel
Formulas and Functions

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 12, 2021

    Twopir 

    If you display more decimal places, you will most probably see that the values are not exactly 25,000.00 and 14,809.57. For example:

    If it is essential to use the values with 2 decimal places, use

    =ROUND(C8,2)-ROUND(C28,2)

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Oct 12, 2021
    If C8 and C28 are cells which show the result of a calculation it is likely that those cells do not contain the EXACT values that you think they do. You'll have to explicitly round the numbers first before subtracting them to get an outcome as you might be expecting. Does this formula give you the expected outcome:
    =ROUND(C8,2)-ROUND(C28,2)

Resources