MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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