You can us the Excel round funtion to round to the nearest multiple of ten.

For example if cell A1 contained the number 16, the function to round this
number to 20 would be: =round(A1,-1).

Hopefully this helps :-)

"Tilly" wrote:

I have a spreadsheet that gives me the total number of people passing through
our gates each year for each site, however I need to round up the numbers to
the nearest mulitple of ten for our brochure numbers, is there an easy way to
do this or is it a case of putting them in manually/