Rounding to the nearest 10

Posted by Kevin on January 04, 2001 6:44 PM

Can anyone tell me how to format a cell of write a formula to round a number to the nearest 10.
785 to 790 OR
784 to 780

Thanks,

Posted by cpod on January 04, 2001 6:47 PM

Try:
=round(A1,-1)

Posted by Kevin on January 04, 2001 6:56 PM

Thank You