how to change rounding rules?

[miaco11]

The formula of round currently rounds up if the decimal value is 0.5 and above and rounds down if the decimal value is below 0.5.

Is there a way to change this? I want a round up if the decimal value is 0.8 and above and round down if the decimal value is 0.7 and below.

E.g.
If value is 2.7, value will become 2
If value is 1.8, value will become 2

Thanks!

 

[Jon von der Heyden]

Try

=ROUND(A1-0.3,0)

 

[miaco11]

Thank you so much for the reply Jon.

I actually used this since i expect 4 levels only (probably a longer way of computing it):

=IF(OR(C37="Sr. Supervisor",C37="Supervisor (Supervising)",C37="Supervisor (Non-supervising)"),LOOKUP(H37,{0,0.7,1.7,2.7,3.7},{"0","1","2","3","4"}),ROUND(H37,0))

=IF(OR(C37="Sr. Supervisor",C37="Supervisor (Supervising)",C37="Supervisor (Non-supervising)"),ROUND(H37-.3,0),ROUND(H37,0)) THIS IS PERFECT!!!

Thank you very much!