How can I round a percentage up in Excel to the closest 5% increment? For example:
1) The calculated percentage in Excel is 8% and I need it to be rounded up to 10%
2) The calculated percentage in Excel is 22% and I need it to be rounded up to 25%
Thanks in advance for your assistance.
Use CEILING.MATH, or CEILING
Ex: =CEILING.MATH(A2,0.05)
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Something like =CEILING(value,0.05)?
Originally Posted by shg
Thank you. This worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks