Round to nearest 5

[elad]

Hi, cant find a formula that round to nearest 5. Just rounddown and round up. I. e if the value is from 130,01 - 132,49 it will be 130. If the value is 132,50 - to 134,99 it will be 135.

Thanks!

Elad
Norway

[dilipandey]

Hi Elad,

If I go through with your descripton, you need round to nearest 500 and not 5.
Use following formula to obtain the desired result:-

=(MROUND(C11,500))/100

where cell c11 contains your values.

Regards,
DILIPandey

<click on below 'star' if this helps>

[optomyst]

Hi, Elad,

MROUND is the best function.... =MROUND(A1,5) , that is taking into account your "," is your decimal point.

[daddylonglegs]

Note that MROUND is an add-in function in Excel 2003 and earlier excel versions (it's part of Analysis ToolPak), so if you can't use that add-in or you don't want to you can use a modified version of ROUND, i.e.

=ROUND(A1/5,0)*5

[elad]

Thanks everyone! It all works fine

Elad
Norway