How do I round numbers to the nearest multiple of 10 or 5?

[Guest]

Using Excel Office 2000, I'm calculating the quantity and value of vaccines
remaining in end-of-year inventory according to 3 different funding
categories (from which vaccine was purchased) and according to package size.
Package sizes are multiples of 5 or multiples of 10, depending on the
vaccine. For example, there are a total of 400 doses of DT in inventory.
Using percentages, 133 doses of DT were purchased using fund #2 and 267 doses
were purchased using fund #3 (fund #1 was not used for purchase of DT). How
do I round to the nearest multiple of 10 in Excel so that the ending result
still equals 400 doses when added together?

 

[Bob Phillips]

To round to nearest 10

=ROUND(A1,-1)

to nearest 5

=ROUND(A1/5,0)*5

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Dav]

10 =ROUND(A1,-1)
5 ==ROUND(2*A1,-1)/2

if your value is in a1

regards

Dav

 

[Guest]

Hi, here are some tips regarding this

http://www.j-walk.com/ss/excel/usertips/tip011.htm

maybe it could help you

regards


"Wasatch" escreveu:

 

[Die_Another_Day]

What do y'all have against MROUND?

=MROUND(A1,10)
=MROUND(A1,5)

Die_Another_Day