Rounding .59 down

[mack11]

I need help rounding numbers up to .6 down, and from .6 and higher round up. The problem is rounding functions start rounding up at .5

Example here: 405,128.53 I want rounded to 405,128.
405,128.61 needs rounded to 405,129.

 

[barry houdini]

Hello mack11, welcome to MrExcel

If your number is in A1 try

=ROUND(A1-0.1,0)

 

[sr12345]

=if(a1-int(a1)<0.6, int(a1), int(a1)+1)