View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default Subtracting two 2-decimal place numbers gives result 13-decimal pl

67083.97 - 61179.17 = 5904.80, not 95.20.

As David Biddulph noted, Excel represents numbers in binary, and in binary
most terminating decimal fractions can only be approximated. As documented
in Help, the level of approximation may be accurate to no more than 15
decimal digits. If whatever calculation you actually performed still seems
wrong recognizing that you may not know what is in the 16th figure of your
input numbers, then post back with correct information.

Jerry

" wrote:

first cell, the value: 61179.17
second cell, the value: 67083.97
third cell, formula subtracting first cell value from the second.
instead of 95.20, the result is actually 95.19999999999710
Whats up?