View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amy6514 Amy6514 is offline
external usenet poster
 
Posts: 1
Default Formulas do not add up to original value

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!?