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?