Any floating point calculations made by any computer is only going to be an
'approximation'. The fact that you are making many calculations on small
floating point exaggerates it. You may want to check out the ROUND, CEILING
or FLOOR functions to overcome this or at least get reliable results

For a better explanation of computer science and floating point maths, look
here

http://www.cpearson.com/excel/rounding.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"p4t" wrote in message
...


I am a newbie on Excel, and I need help.

=TRUNC((59,4-59)/0,2)
returns 1 !!!!

Can anyone explain me why this happens????
Please help, I do not have much time.
Thanks in advance!


--
p4t
------------------------------------------------------------------------
p4t's Profile:
http://www.excelforum.com/member.php...o&userid=25392
View this thread: http://www.excelforum.com/showthread...hreadid=388653