Oct 12 2021 02:22 AM
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
Oct 12 2021 02:42 AM
Oct 12 2021 02:44 AM
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)