Forum Discussion
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...
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)