Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONCATENATE problem | Excel Worksheet Functions | |||
Concatenate Problem | Excel Discussion (Misc queries) | |||
Concatenate Problem | New Users to Excel | |||
Concatenate Problem | Excel Worksheet Functions | |||
concatenate problem | Excel Worksheet Functions |