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 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)
=ROUND(C8,2)-ROUND(C28,2)