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,

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,

=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/