rounding to 5 cents

[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

 

[Don Guillett]

Did you try the archives? or google?

 

[Chip Pearson]

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)

 

[Stephen Dunn]

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)

 

[Jim Becker]

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!