How do you round up to nearest 10???

Hello, just a quick one

How do you round a figure up to the nearest 10?
I currently use "=ROUNDUP(H82,0)" and thats great but only rounds up to the nearest whole digit.

Please help
thank you
Dave

=CEILING(A1,10)

which is more efficient than

=ROUNDUP(A1/10,0)*10

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"davemate" <[email protected]> wrote in
message news:[email protected]...
>
> Hello, just a quick one
>
> How do you round a figure up to the nearest 10?
> I currently use "=ROUNDUP(H82,0)" and thats great but only rounds up to
> the nearest whole digit.
>
> Please help
> thank you
> Dave
>
>
> --
> davemate
> ------------------------------------------------------------------------
> davemate's Profile:
> http://www.excelforum.com/member.php...o&userid=34364
> View this thread: http://www.excelforum.com/showthread...hreadid=552534
>