rounding to 5 cents

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
 
S

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)
 
J

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!
 
Top