Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Pamela Baker   on Dec 27 In MS Office Category.

  
Question Answered By: Brent Brown   on Dec 27

I'm just wondering if you realize that to accomplish what you're asking
would require someone to override a correct mathematical calculation.



The inequality you're experiencing is simply a risk associated with
truncating precise numbers and if that level of precision isn't
aesthetically pleasing or confuses your audience, rounding  to one
decimal place will probably get you where you need to be.



10% + 10% + 30% + 20% + 10% +20% = 100%



FYI - the numbers will finally equal 100.0000% when rounded to five
decimal places.

Share: 

 
 
Didn't find what you were looking for? Find more on Percentage Rounding VBA Or get search suggestion and latest updates.


Tagged: