rounding up or down

A

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
 
J

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
 
Top