rounding up or down

[alecgreen]

Is it possible to round up or down numbers in a column to the nearest 5

or 0. For example
872 = 870, 1056 = 1060.

Many Thanks


Alec

 

[Max]

Assuming numbers in A1 down,
Try in B1: =ROUND(A1,-1)
Copy down

 

[Jerry W. Lewis]

To the nearest 5 or the nearest 10? To the nearest 5, 1056 would become
1055.

=ROUND(x/5,0)*5
rounds to the nearest 5.

=ROUND(x,-1)
rounts to the nearest 10, as Max has already noted.

Jerry

 

[alecgreen]

Thank you guys for your help

Alec