software

I got an odd problem in Excel.

The problem is that if i take 4.5 (Minus) 4.4, that will result in 0.1
but if i choose 16 decimals it will go random like this
0,0999999999999996
0,0999999999999997
0,0999999999999999

other combinations also apply too this.
is there a solution too this one?

hope some Excel man can fix this for me as it is a huge problem
support.microsoft.com/kb/78113

--
Kind regards,

Niek Otten

quot;Ronny Andersenquot; lt;Ronny gt; wrote in message
...
gt;I got an odd problem in Excel.
gt;
gt; The problem is that if i take 4.5 (Minus) 4.4, that will result in 0.1
gt; but if i choose 16 decimals it will go random like this
gt; 0,0999999999999996
gt; 0,0999999999999997
gt; 0,0999999999999999
gt;
gt; other combinations also apply too this.
gt; is there a solution too this one?
gt;
gt; hope some Excel man can fix this for me as it is a huge problem
gt;
gt;

This was all Discussed on a thread a few days ago
www.excelforum.com/showthread.php?t=519628

Entitled 'Problem withe ABS Function' and posed in the formula section
of this site.

Jerry W. Lewis explains it very clearly

Regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=520491