Apple iWork '09 User Manual

Page 369

Index

369

IF 158, 358
IFERROR 159
ISBLANK 160 , 358
iserror 161
ISEVEN 162
ISODD 163
NOT 164
OR 165, 358
TRUE 166

LOGINV statistical function 268
LOGNORMDIST statistical function 269
LOOKUP reference function 217
LOWER text function 316

magnetism conversion units 82
MATCH reference function 218, 361
MAX statistical function 270
MAXA statistical function 270
MEDIAN statistical function 271
metric prefixes for conversion units 83
MID text function 316
MIN statistical function 272
MINA statistical function 273
MINUTE date and time function 52
MIRR financial function 128, 350
MOD numeric function 182
modal argument defined 35
modal value type 38
MODE statistical function 274
MONTH date and time function 53
MONTHNAME date and time function 54
MROUND numeric function 183, 355
MULTINOMIAL numeric function 184

NASD days-basis method 342
navigating to table cells referenced in formulas 26
NEGBINOMDIST statistical function 275
NETWORKDAYS date and time function 54
NOMINAL financial function 129, 351
NORMDIST statistical function 276
NORMINV statistical function 277
NORMSDIST statistical function 277
NORMSINV statistical function 278
NOT logical and information function 164
NOW date and time function 55
NPER financial function 130, 348, 351
NPV financial function 132, 350
number value type 38
numeric function

CEILING 355
EVEN 355
FLOOR 355
INT 355
MROUND 355

ODD 355
ROUND 356
ROUNDDOWN 356
ROUNDUP 357
TRUNC 357

numeric functions

ABS 170
CEILING 170
COMBIN 172
EVEN 173
EXP 174
FACT 174
FACTDOUBLE 175
FLOOR 176
GCD 177
INT 178
LCM 179
LN 179
LOG 180
LOG10 181
MOD 182
MROUND 183
MULTINOMIAL 184
ODD 185
PI 186
POWER 186
PRODUCT 187
QUOTIENT 188
RAND 189
RANDBETWEEN 189
ROMAN 190
ROUND 191
ROUNDDOWN 192
ROUNDUP 193
SIGN 195
SQRT 195
SQRTPI 196
SUM 196
SUMIF 197, 360
SUMIFS 198, 360
SUMPRODUCT 200
SUMSQ 201
SUMX2MY2 202
SUMX2PY2 203
SUMXMY2 204
TRUNC 204

NUMTOBASE mathematical function 92

OCT2BIN engineering function 93
OCT2DEC engineering function 94
OCT2HEX engineering function 95
ODD numeric function 185, 355
OFFSET reference function 219
operators

arithmetic 28