rounding to 5 cents

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

What is the easiest way to round the results of the calculations to the
whole 5 cents i.e. 5.22 will result in 5.20, 5.24 in 5.25, 5.27 in 5.25,
5.28 in 5.30 etc.

Thanks for any suggestions.

Tony
 
Tony,

Try the MROUND function. E.g.,
=MROUND(A1,0.25)

See Help for more details.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
I think Chip meant:

=MROUND(A1,0.05)

and if you haven't got MROUND, you'll find it in the Analysis Toolpak
add-in. Without the add-in, one possibility:

=0.05*INT((A1+.025)/.05)
 
Check out the CEILING worksheet function.

From the Help file:
Returns number rounded up, away from zero, to the nearest
multiple of significance. For example, if you want to avoid
using pennies in your prices and your product is priced at
$4.42, use the formula =CEILING(4.42,0.05) to round prices
up to the nearest nickel.

Hope this helps,
James dot Becker at NCR dot com
~
~
~
:wq!
 
Don,

Thanks a lot for you informative, intelligent and insightful response to Tony's question!!!
With your excellent suggestions, we can close down the newsgroups all together, and
just use "google".

Many of us come here to get the personal attention from the many experts who come
here to assist those of us who are beginners, laymen, or in some cases, experts who also
need help.

I appologize to Tony for your inconsiderate and uninformed response to his question.

Bernie
 
Back
Top