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

how about this?

=ROUNDUP(H82/10,0)*10


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=552534

=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" wrote in
message ...

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