Rounding Up or Down

B

BLG

I need to round a series of numbers to the hundreth
decimal place.

So in this list a numbers below, I want these numbers:

211.30724
346.2669
172.22724

to round up and down to the following:

211.31
346.27
172.28

How do a set up a function to do this?
 
T

Tom Wickerath

The built-in ROUND function should work for your first two examples. I suspect you meant to show
172.23 for your third example. The syntax is:

Round(expression [,numdecimalplaces])

The Round function syntax has these parts:

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


Tom
______________________________________


I need to round a series of numbers to the hundreth
decimal place.

So in this list a numbers below, I want these numbers:

211.30724
346.2669
172.22724

to round up and down to the following:

211.31
346.27
172.28

How do a set up a function to do this?
 
Top