Banker's Rounding - need help!

  • Thread starter Thread starter Somecallmejosh
  • Start date Start date
S

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
 
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.
Click to expand...

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.
 
Somecallmejosh said:
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
Click to expand...
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
 
Back
Top