Round number up or down to nearest 5 or 10?

External Since: Aug 25, 2003 Posts: 1

I know I can use ROUND(14,-1) to get the number 14 to round to 10 or 18
to round to 20...
but is there a way to get the number to round to the nearest 5 or 0 in
the singles digit? Ie. have 14 round to 15 and 18 still round to 20?

Thanks

External Since: Aug 27, 2003 Posts: 11

ouxi wrote :

> I know I can use ROUND(14,-1) to get the number 14 to round to 10 or 18
> to round to 20...
> but is there a way to get the number to round to the nearest 5 or 0 in
> the singles digit? Ie. have 14 round to 15 and 18 still round to 20?

If you have the Analysis Tool Pack add-in (Tools -> Add-ins) installed,
there is a "MROUND" function you can use. So you can write "=MROUND(A1,5)"

If the workbook has to be sent over (to people who won't necessarily have
the add-in installed) you can also use "=ROUND(A1*2,-1)/2"

I Guess that would do Smile

---------------------------------------------------------
Please reply to the newsgroup, and within the same thread.
Merci de répondre au groupe, et dans l'enfilade.

--
Bernard Rey - Toulouse / France
MVP - Macintosh