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

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

In terms of pence, 2 rounds to the nearest 1 pence, 3 to the nearest 0.1
pence. Basically these are the decimal places you want to round to.

Mangesh



"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

2 goes to .01, 3 to .001. where 1 rounds to .1.

--
HTH

Bob Phillips

"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