I am looking at a more accurate way to round numbers off. The problem is
that excel wants to stick to the simple method. I am looking for a formula
that looks at the digits beond the five for exaplme 8.356=8.4, 8.353=8.3,
8.355=8.3.

You will first have to explain your rounding algorithm, since it is not
obvious from your examples.

Jerry

"sloancm" wrote:

I am looking at a more accurate way to round numbers off. The problem is
that excel wants to stick to the simple method. I am looking for a formula
that looks at the digits beond the five for exaplme 8.356=8.4, 8.353=8.3,
8.355=8.3.

when rounding I need to look at the digits behind the five to determine which
way to round up or down. 10.26=10.3, 12.6558=12.7, 52.3552=52.3. It is
basically looking at 0.55555... as the center point not .5

Trent

"Jerry W. Lewis" wrote:

You will first have to explain your rounding algorithm, since it is not
obvious from your examples.

Jerry

"sloancm" wrote:

I am looking at a more accurate way to round numbers off. The problem is
that excel wants to stick to the simple method. I am looking for a formula
that looks at the digits beond the five for exaplme 8.356=8.4, 8.353=8.3,
8.355=8.3.

Ignoring the vagaries of binary approximations (where 5/9=0.55555... has no
exact binary representation and the exact approximation used will depend on
what precedes it), you may be happy with
=IF(ABS(A1)*10-INT(ABS(A1)*10)<5/9,ROUNDDOWN(A1,1),ROUNDUP(A1,1))
to round a number in A1.

Jerry

"sloancm" wrote:

when rounding I need to look at the digits behind the five to determine which
way to round up or down. 10.26=10.3, 12.6558=12.7, 52.3552=52.3. It is
basically looking at 0.55555... as the center point not .5

Trent

"Jerry W. Lewis" wrote:

You will first have to explain your rounding algorithm, since it is not
obvious from your examples.

Jerry

"sloancm" wrote:

I am looking at a more accurate way to round numbers off. The problem is
that excel wants to stick to the simple method. I am looking for a formula
that looks at the digits beond the five for exaplme 8.356=8.4, 8.353=8.3,
8.355=8.3.