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

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

"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.
>
> 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.

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 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.
>
> 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