Rounding up to the nearest 10 (or 100, or 1000)

We've looked in the past at how to round up (or down) to the nearest x decimal places, or whole number, but someone asked me the other day how to round up to the nearest £10 (or € or $). This is very easy to do, but first, a quick re-cap on the ROUNDUP (or ROUNDDOWN or ROUND) function…

The ROUND group of functions works like this: =ROUND(cell_ref, no_of_decimals), so =ROUND(A1, 2) would round the value in cell A1 to 2 decimal places, and ROUNDUP(B2, 0) would round upwards to the nearest whole number. Easy, huh?

To round to the nearest 10, we use the same format, but move into negative numbers for the second part of the formula, so =ROUND(C3, -1) would round the value in cell C3 to the nearest 10.

So there you go, a quick look at more advanced use of the ROUND group of functions.

By Neil Shorney

Did you know, we now offer live e-learning courses for all levels of Excel - visit http://www.nsales.co.uk/microsoft_excel_training for more info.