Help with sum up or down in cells

K

Kim Kappel

Hi.

I need help for the following:

I need to sum up or down the value of a cell to the nearest 5 or 10

If a cell shows 1 it must be corrected to 0
If a cell shows 7 it must be corrected to 5
If a cell shows 8 it must be corrected to 10
If a cell shows 21 it must be corrected to 20
If a cell shows 23 it must be corrected to 25

BR Kim
 
A

aristotle

Hi,

The MROUND() function available after installing Analysis Toolpak allows you
to define the rounding multiple. So if in A1 you have 4, the =MROUND(A1,5) =
5...

Tools->Addins->Analysis Toolpak to install...
 
Top