If your system ends up kicking out a VBA code, try using this formula. Copy and paste it into whatever cell you want. Assume that the number you wish to round is in cell C4.
=IF(ROUND(C4,0)=ROUND(C4-0.1,0),ROUND(C4,0),IF(ISEVEN(ROUND(C4,0)),ROUND(C4 ,0),ROUNDDOWN(C4,0)))
|