Yes I had a typo in my sum, it should've been sum(c10:C13) good catch
!

Thank you for the explanation but it still doesn't explain why I could
use other numbers to add up to 28853.09 and be fine or even simply type
28853.09 in that field and not use the sum function.

Should I use the round function EVERY time I use the sum function so
that this can't happen ?

If someone could elaborate I would appreciate it.


--
ddelong
------------------------------------------------------------------------
ddelong's Profile: http://www.excelforum.com/member.php...o&userid=25045
View this thread: http://www.excelforum.com/showthread...hreadid=385677