LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 661
Default Odd Concatenate problem.

Running XP Pro with Office 2003 pro upto SP2.

=CONCATENATE(C6-D6," ans")

Where C6 is 8.2 and D6 is 8.1
The answer I get is 0.0999999999999996 ans. Extending the range of numbers
I get: -
1.2 1.1 0.0999999999999999 ans
2.2 2.1 0.1 ans
3.2 3.1 0.1 ans
4.2 4.1 0.100000000000001 ans
5.2 5.1 0.100000000000001 ans
6.2 6.1 0.100000000000001 ans
7.2 7.1 0.100000000000001 ans
8.2 8.1 0.0999999999999996 ans
9.2 9.1 0.0999999999999996 ans
10.2 10.1 0.0999999999999996 ans
11.2 11.1 0.0999999999999996 ans
12.2 12.1 0.0999999999999996 ans
13.2 13.1 0.0999999999999996 ans
14.2 14.1 0.0999999999999996 ans
15.2 15.1 0.0999999999999996 ans
16.2 16.1 0.0999999999999979 ans
17.2 17.1 0.0999999999999979 ans
18.2 18.1 0.0999999999999979 ans
19.2 19.1 0.0999999999999979 ans
20.2 20.1 0.0999999999999979 ans
21.2 21.1 0.0999999999999979 ans
22.2 22.1 0.0999999999999979 ans
23.2 23.1 0.0999999999999979 ans
24.2 24.1 0.0999999999999979 ans
25.2 25.1 0.0999999999999979 ans
26.2 26.1 0.0999999999999979 ans
27.2 27.1 0.0999999999999979 ans
28.2 28.1 0.0999999999999979 ans
29.2 29.1 0.0999999999999979 ans
30.2 30.1 0.0999999999999979 ans
31.2 31.1 0.0999999999999979 ans
32.2 32.1 0.100000000000001 ans
33.2 33.1 0.100000000000001 ans
34.2 34.1 0.100000000000001 ans
35.2 35.1 0.100000000000001 ans
36.2 36.1 0.100000000000001 ans

This is very odd. Any Ideas? Only two of the above are correct, but of
couse all of them should read 0.1

 
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
CONCATENATE problem Mark Dullingham Excel Worksheet Functions 6 March 6th 07 12:11 AM
Concatenate Problem singh Excel Discussion (Misc queries) 3 February 9th 07 06:50 PM
Concatenate Problem John Calder New Users to Excel 3 November 13th 06 10:39 PM
Concatenate Problem aisos12 Excel Worksheet Functions 2 October 28th 06 03:57 AM
concatenate problem joe peters Excel Worksheet Functions 9 May 29th 05 06:34 AM


All times are GMT +1. The time now is 08:38 AM.

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

About Us

"It's about Microsoft Excel"