rounding to the left of the decimal (100's)

[Guest]

I am going nuts trying to round to the nearest 100 ..

the help base says

"Round(expression [,numdecimalplaces]

The Round function syntax has these parts

Part Description
expression Required. Numeric expression being rounded.
numdecimalplaces Optional. Number indicating how many places to the right of the decimal are included in the rounding. If omitted, integers are returned by the Round function.

In Excel, the formula to round to the nearest hundred (two places to the LEFT of the decimal) is simply "Round(expression,-2), but I've tried every conceivable combination of

[,-2
,[-2
,-
,-[2

in the "numdecimalplaces" and I simply cannot get it to round to the nearest 100

If it matters, I've got Access 2003 and this particular formula is in a "Control" (text box)

Can anyone explain how to round to the hundreds position (two digits left of the decimal ?)

 

[Randy Harris]

Note your quote from Help "how many places to the right of the decimal".
It doesn't do to left of decimal.

Try:

Round(expression / 100) * 100

That will round to the nearest hundred.

HTH,
Randy

I am going nuts trying to round to the nearest 100 ...

the help base says:

"Round(expression [,numdecimalplaces])

The Round function syntax has these parts:

Part Description
expression Required. Numeric expression being rounded.
numdecimalplaces Optional. Number indicating how many places to the right

of the decimal are included in the rounding. If omitted, integers are
returned by the Round function. "

In Excel, the formula to round to the nearest hundred (two places to the

LEFT of the decimal) is simply "Round(expression,-2), but I've tried every
conceivable combination of:

[,-2]
,[-2]
,-2
,-[2]

in the "numdecimalplaces" and I simply cannot get it to round to the nearest 100.

If it matters, I've got Access 2003 and this particular formula is in a "Control" (text box).

Can anyone explain how to round to the hundreds position (two digits left of the decimal ?)