You don't give us any formulas, so it is difficult to tell what might be
wrong.
Anyway, the addition you give as an example is perfectly OK!

Please post values, formulas, expected and acrtual results so we might be
able to help

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Amy6514" wrote in message
...
I have a spreadsheet that works out how much of a set amount should be
divided between different cells. However the figures it works out then do
not
add up to the original amount that I started with. i.e. it splits 160 into
40.31, 39.45, 36.69 and 43.56 - which addes up to 160.01. How do I stop
that!?