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

[Wasatch]

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?

[Dav]

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

if your value is in a1

regards

Dav

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

"Wasatch" <[email protected]> wrote in message
news:[email protected]...
> 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?
>

[Marcelo]

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:

> 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?
>

[Die_Another_Day]

What do y'all have against MROUND?

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

Die_Another_Day


Dav wrote:
> 10 =ROUND(A1,-1)
> 5 ==ROUND(2*A1,-1)/2
>
> if your value is in a1
>
> regards
>
> Dav
>
>
> --
> Dav
> ------------------------------------------------------------------------
> Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
> View this thread: http://www.excelforum.com/showthread...hreadid=558461