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