From "Help"

ROUND
See Also

Rounds a number to a specified number of digits.

Syntax

ROUND(number,num_digits)

Number is the number you want to round.

Num_digits specifies the number of digits to which you want to round
number.

If num_digits is greater than 0 (zero), then number is rounded to the
specified number of decimal places.


If num_digits is 0, then number is rounded to the nearest integer.


If num_digits is less than 0, then number is rounded to the left of the
decimal point.

Examples

ROUND(2.15, 1) equals 2.2

ROUND(2.149, 1) equals 2.1

ROUND(-1.475, 2) equals -1.48

ROUND(21.5, -1) equals 20



"Louise" wrote in message
...
Hi all

When using the Round function, ,1 rounds to the nearest 10 pence, -1
rounds
to the nearest 10 unit and 0 to the nearest whole numer.

If I were to enter ,2 or ,3 etc. what do these options do??

Thank you.

Louise