How can I roundup to next 0 i.e. 71 to 80?

C

Cheryl

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,
 
S

Sven

=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.
 
Top