Apple Pages 2 - Manual (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
1
...) The product of the
arguments PRODUCT(2, 4) returns
8 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
1
...) The sum of the
arguments SUM(1, 2) returns 3
SUM(1, TRUE) returns
2 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.