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 <[email protected]>,
JE McGimpsey <[email protected]> wrote:

> One way:
>
> =ROUND(A1,0)-(MOD(A1,1)=0.5)