Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 12th 07, 08:52 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 2
Default Subtracting two 2-decimal place numbers gives result 13-decimal places?

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?


  #2   Report Post  
Old March 12th 07, 09:16 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default Subtracting two 2-decimal place numbers gives result 13-decimal places?

Or it may just be the fact that those decimal numbers cannot be represented
exactly by fixed point binary numbers.
As an exercise, try to work out the binary representation of 61179.17, and
of 67083.97.
--
David Biddulph

"CLR" wrote in message
...
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?





  #3   Report Post  
Old March 12th 07, 09:18 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 2
Default Subtracting two 2-decimal place numbers gives result 13-decimal places?

On Mar 12, 2:10 pm, "CLR" wrote:
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?- Hide quoted text -


- Show quoted text -


Thanks, but I tried that . . . so I re-entered the numbers by hand
with only the two decimal places, and still get the extra significant
figures when I format the result to show them.

  #4   Report Post  
Old March 12th 07, 09:22 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
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?



  #5   Report Post  
Old March 12th 07, 10:10 PM posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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?





  #6   Report Post  
Old March 12th 07, 10:38 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Decimal places and subtracting bjscheel Excel Discussion (Misc queries) 2 January 5th 07 03:17 PM
Converting 2-place decimal value to floating point decimal number with leading zero Kermit Piper Excel Discussion (Misc queries) 3 March 18th 06 06:20 PM
Highest & lowest place value / decimal places of cell value Neil Goldwasser Excel Worksheet Functions 2 March 15th 06 02:27 PM
My numbers format as a number with two decimal places. Tim Poulter Excel Discussion (Misc queries) 2 September 18th 05 01:42 AM
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. SUKYKITTY Excel Discussion (Misc queries) 3 July 6th 05 01:50 PM


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017