Rounding issue

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..
 
A

Andy B

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.
 
C

CharAp

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding a number to a multiple quantity that adds to a fixed total number 1
Rounding question 9
Inconsistent rounding using Long Integer 2
Rounding issue 5
My Excel totals are always 1 or 2 cents too low. Any ideas? 2
Rounding 2
Rounding formula question 4
Problem editing a query based on another query and table 3

Top