Hi, hopefully this is a simple one.
I have a formula containing percentages of 11 which I need to result in whole numbers.
I'm adding 41.7% + 35.7% + 15.8% +5.6% + 1.2%. (100%)
This produces rounded figures of
5 + 2 + 4 + 1 = 12
Is there a way for me to get this to result in the correct answer of 11.
Many thanks
Bookmarks