Banker's Rounding - need help!

[Somecallmejosh]

I understand that Excel, unlike Access, will not do
Banker's Rounding. Ultimately, 1.05 under Banker's
Rounding will round to 1.0. Under traditional rounding,
it will round to 1.1.

I have tried subtracting .04 and then applying the
rounding procedure in Excel to acheive the same results.
However, numbers like 1.09, with the calculation will
yield a result of 1.05, which still rounds to 1.1. Is
there some other Mathematical means of achieving the
desired results in Excel.

Sincerely,
Josh

 

[Guest]

Hi, josh;
Does ROUNDDOWN appear in your function list?
-IanRoy

 

[Harlan Grove]

Somecallmejosh wrote...

I understand that Excel, unlike Access, will not do
Banker's Rounding. Ultimately, 1.05 under Banker's
Rounding will round to 1.0. Under traditional rounding,
it will round to 1.1.

I have tried subtracting .04 and then applying the
rounding procedure in Excel to acheive the same results.
However, numbers like 1.09, with the calculation will
yield a result of 1.05, which still rounds to 1.1. Is
there some other Mathematical means of achieving the
desired results in Excel.

Banker's rounding is only applicable to rounding to N significant
digits when the N+1_th digit is a 5. So at 2 significant digits (N=2),
1.09 *should* round to 1.1, not 1.0. For that matter, 1.06 should also
round to 1.1. If you mean 1.0x should round to 1.0 while 1.1x should
round to 1.2 for any x in 0..9, you're not talking about bankers
rounding.

This has been discussed before. Check the Google Groups archives for
the Excel newsgroups.

 

[ron]

I understand that Excel, unlike Access, will not do
Banker's Rounding. Ultimately, 1.05 under Banker's
Rounding will round to 1.0. Under traditional rounding,
it will round to 1.1.

I have tried subtracting .04 and then applying the
rounding procedure in Excel to acheive the same results.
However, numbers like 1.09, with the calculation will
yield a result of 1.05, which still rounds to 1.1. Is
there some other Mathematical means of achieving the
desired results in Excel.

Sincerely,
Josh

I don't have my excel with we, but the later versions of VBA do bankers
rounding.

Something like:

Function BRound (num, places) as double
BRound = Round (num, places)
End function

in a regular module should work

ron