Rounding issue

  • Thread starter Thread starter CharAp
  • Start date Start date
C

CharAp

I have a quuery regarding rounding. I have a sheet where I have a tota
variable quantity that is split between 5 different areas in a ratio.
My problem is that if say the qty to split is 17 and the ratio is 8:4:
then the results are 10.46, 5.23 and 1.31. The rounded results ar
10,5 and 1 which total 16. How can I ensure that figures are rounde
to 0 decimal places but that if there is a difference between th
rounded totals and the original total an extra 1 is added to the firs
rounded figure (or preferably the highest rounded figure)?

Please assist..
 
Hi

Make the highest rounded figure not a calculation. Just take the sum of the
rest away from the total you want and use that in its place.

Andy.
 
But that wont be automatic, wont I have to make this change for eac
line in the worksheet, 1000+

Sorry if I have misunderstood you
 
Back
Top