The ROUND function

[Guest]

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

 

[CLR]

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

 

[Mangesh Yadav]

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

 

[Bob Phillips]

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