View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Paul is offline
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