Thread: Subtracting two 2-decimal place numbers gives result 13-decimal places?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Subtracting two 2-decimal place numbers gives result 13-decimal places?
I assume that you mean 61083.97, not 67083.97, and that you mean
"subtracting second cell value from the first", not "subtracting first cell
value from the second"?

See my answer elsewhere in the thread for the explanation.
--
David Biddulph

wrote in message
ups.com...
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?



Reply With QuoteReply With Quote