Apple Numbers '08 Manual do Utilizador descarregar pdf (Página 268)

268 Chapter 12 Dictionary of Functions

ROUND

The ROUND function rounds a number to the specified number of places.

ROUND(number, digits)

Â number: The number you want to round. It can be a numeric expression in the

function or a reference to a cell containing a numeric expression.

Â digits: The number of digits you want to round to, relative to the decimal point. A

positive number represents digits (decimal places) to the right of the decimal point.

A negative number specifies digits to the left of the decimal point.

Notes

Other functions related to rounding numbers: CEILING, INT, ROUNDUP, ROUNDDOWN,

TRUNC.

ROUNDDOWN

The ROUNDDOWN function rounds a number toward zero to the specified number of

places.

ROUNDDOWN(number, digits)

Â number: The number you want to round. It can be a numeric expression in the

function or a reference to a cell containing a numeric expression.

Â digits: The number of digits of the result relative to the decimal point. A positive

number represents digits (decimal places) to the right of the decimal point. A

negative number specifies digits to the left of the decimal point.

Examples

ROMAN(12) returns XII.

ROMAN(999) returns CMXCIX.

ROMAN(999,1) returns LMVLIV.

ROMAN(999,2) returns XMIX.

ROMAN(999,3) returns VMIV.

ROMAN(999,4) returns IM.

Examples

ROUND(1.49,0) returns 1.

ROUND(1.50,0) returns 2.

ROUND(1.23456,3) returns 1.235.

ROUND(1111.222,-2) returns 1100.

ROUND(-2.2,0) returns -2.

ROUND(-2.8,0) returns -3.

1 2 ... 263 264 265 266 267 268 269 270 271 272 273 ... 294 295

Sem comentários

Apple Numbers '08 Manual do Utilizador Página 268