Thread: Subtracting two 2-decimal place numbers gives result 13-decimal places?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
  
Posts: 594
Default Subtracting two 2-decimal place numbers gives result 13-decimal places?
Probably either the first or the second cell is the result of a formula
giving the multiple decimal places and formatted to only show the
two.........

Vaya con Dios,
Chuck, CABGx3


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