Hi everyone,
This is potentially more of a math question, but I'm hoping there is an excel formula that could also help.
I'm trying to divide a number of shares by percentages with 14 decimals. The end number of shares needs to be a whole number, however whenever I round I am always left with a remainder. Example -
![](/board/proxy.php?image=https%3A%2F%2Fpreview.ibb.co%2FfNwMdk%2FScreen_Shot_2017_09_24_at_12_41_02.png&hash=6632d6cd86115f16320242e0290ce76d)
The example above gives a difference of 3. What is the best way to approach this type of rounding? Is there a formula I can use to ensure the rounded total is 33,557?
Many thanks,
Daniel
This is potentially more of a math question, but I'm hoping there is an excel formula that could also help.
I'm trying to divide a number of shares by percentages with 14 decimals. The end number of shares needs to be a whole number, however whenever I round I am always left with a remainder. Example -
![](/board/proxy.php?image=https%3A%2F%2Fpreview.ibb.co%2FfNwMdk%2FScreen_Shot_2017_09_24_at_12_41_02.png&hash=6632d6cd86115f16320242e0290ce76d)
The example above gives a difference of 3. What is the best way to approach this type of rounding? Is there a formula I can use to ensure the rounded total is 33,557?
Many thanks,
Daniel