Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I roundup to next 0 i.e. 71 to 80?
I need to round up to nearest whole number 0 i.e. 71 to 80, 57 to 60, 13 to
20 etc. There is no decimal places in the figures I am using. Thanks, |
#2
|
|||
|
|||
Hi
=ROUNDUP(A1,-1) Also see: http://www.xldynamic.com/source/xld.Rounding.html "Cheryl" wrote: I need to round up to nearest whole number 0 i.e. 71 to 80, 57 to 60, 13 to 20 etc. There is no decimal places in the figures I am using. Thanks, |
#3
|
|||
|
|||
=10*(ROUNDUP(CELL/10,0))
Where CELL is the number you need rounded. It will first divide that number by 10 (so 71 becomes 7.1), then round that number up (so 7.1 becomes 8), then re-multiply by 10 (so 8 becomes 80). Cheers,Sven. On Sat, 20 Nov 2004 01:51:03 -0800, Cheryl wrote: I need to round up to nearest whole number 0 i.e. 71 to 80, 57 to 60, 13 to 20 etc. There is no decimal places in the figures I am using. Thanks, -- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I roundup to the nearest 9 | New Users to Excel |