Banker's rounding formula in Excel

Use this formula:

=IF(AND(ISEVEN(A1*10^0),MOD(A1*10^0,1)<=0.5),ROUNDDOWN(A1,0),ROUND(A1,0))

Replace all the 0, there are 4 of them, with the significance of the desired rounding.

Or you can create a user defined function to use VBA Round, which is Banker's Rounding:

Function BankerRound(rng As Double, sig As Integer) As Double

    BankerRound = Round(rng, sig)
End Function

Then it would simply be:

=BankerRound(A1,0)

Related