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.