Apple Pages Guide de l'utilisateur télécharger pdf (Page 196)

196 Chapter 8 Creating Tables

Numerical functions perform arithmetic calculations.

This function Returns Examples Notes

ABS(x) The absolute value of

the argument

ABS(3.6) returns 3.6

ABS(–3.6) returns 3.6

ABS(TRUE) returns 1

Interprets TRUE as 1

and FALSE as 0

INT(x) The whole number

nearest the argument

that is no larger than

the argument

INT(3.1) returns 3

INT(3.7) returns 3

INT(–3.1) returns –4

INT(42) returns 42

Interprets TRUE as 1,

and FALSE and

references to empty

cells as 0

MOD(x, y) The remainder after

dividing x by y

MOD(5,2) returns 1

MOD(–1.2,7) returns

5.8

The sign of the

returned value is the

same as the sign of y.

Also see note at end

of table.

PRODUCT(x

...) The product of the

arguments

PRODUCT(2, 4) returns

See note at end of

table.

ROUND(x, y) The number that

results after rounding

x to y decimal places

ROUND(3.1415, 2)

returns 3.14

ROUND(3.1415, –7)

returns 0

ROUND(3.1415, 2.7)

returns 3.14

Rounds y toward 0 to

the nearest integer. If

y, after rounding, is

negative, returns 0.

Also see note at end

of table.

SIGN(x) 1 if x is greater than 0

0 if x is equal to 0

–1 if x is less than 0

SIGN(42) returns 1

SIGN(0) returns 0

SIGN(–42) returns –1

Interprets TRUE as 1,

and FALSE and

references to empty

cells as 0

SUM(x

...) The sum of the

arguments

SUM(1, 2) returns 3

SUM(1, TRUE) returns

Also see note at end

of table.

Notes:

Â If an argument of MOD, ROUND, or SUM is a reference to a cell that

doesn’t contain a number, the argument is ignored. TRUE is interpreted as 1,

FALSE is interpreted as 0, and text strings result in an error.

1 2 ... 191 192 193 194 195 196 197 198 199 200 201 ... 249 250

Commentaires sur ces manuels

Pas de commentaire

Apple Pages Guide de l'utilisateur Page 196

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Apple Pages