Note: that works only for non-negative numbers. If you may be rounding
negative numbers using the same pattern, use

=ROUND(A1,0)-SIGN(A1)*(MOD(A1,1)=0.5)

In article ,
JE McGimpsey wrote:

One way:

=ROUND(A1,0)-(MOD(A1,1)=0.5)