How do you round up to nearest 10???

D

davemate

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 t
the nearest whole digit.

Please help
thank you
Dav
 
P

Peo Sjoblom

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding up to nearest specified whole number 1
round up to nearest 50p 1
How to round up to the nearest five 3
rounding down to nearest 1/32 3
Round time to nearest 15 minutes in decimal format 4
How can I Round up to the nearest .25 11
Round up to nearest 25 or 50? 8
How do I round up to the nearest Dollar in Excel?? 5

Top