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
