beautypg.com

Apple iWork '09 User Manual

Page 370

background image

370

Index

comparison 29
string 30, 310

OR logical and information function 165, 358

P

parentheses syntax elements 34
pasting help examples into a table 41
PERCENTILE statistical function 279
PERCENTRANK statistical function 280
PERMUT statistical function 281
PI numeric function 186
PMT financial function 134, 348, 351, 353
POISSON statistical function 282
power conversion units 82
POWER numeric function 186
PPMT financial function 135, 349, 353
pressure conversion units 81
PRICE financial function 137, 352
PRICEDISC financial function 138
PRICEMAT financial function 140
PROB statistical function 282
PRODUCT numeric function 187
PROPER text function 317
PV financial function 141, 349

Q

QUARTILE statistical function 284
question mark wildcard 30, 361
quick formulas 18
QUOTIENT numeric function 188

R

RADIANS trigonometric function 335
RAND numeric function 189
RANDBETWEEN numeric function 189
range value type 38
RANK statistical function 285
RATE financial function 144, 349
RECEIVED financial function 146, 352
reference function

ADDRESS 207
AREAS 209
CHOOSE 209
COLUMN 210
COLUMNS 211
HLOOKUP 211, 361
HYPERLINK 213
INDEX 214
INDIRECT 216
LOOKUP 217
MATCH 218, 361
OFFSET 219
ROW 221
ROWS 221
TRANSPOSE 222

VLOOKUP 223, 361

reference value type 39
referencing the same cell in multiple tables 39
regular expressions using wildcards 361
relative cell references 27
REPLACE text function 318
REPT text function 319
RIGHT text function 319
ROMAN numeric function 190
ROUND numeric function 191, 356
ROUNDDOWN numeric function 192, 356
rounding 355
ROUNDUP numeric function 193, 357
ROW reference function 221
ROWS reference function 221

S

savings related financial questions 351
search expressions 361
SEARCH text function 320, 361
searching for formulas. See finding and replacing
SECOND date and time function 56
semicolons as argument separators 34
SIGN numeric function 195
SIN trigonometric function 336
SINH trigonometric function 337
SLN financial function 147, 352
SLOPE statistical function 287
SMALL statistical function 288
solving common financial questions 351
speed conversion units 81
spreadsheets

finding and replacing formula elements 32
viewing all formulas in 31

SQRT numeric function 195
SQRTPI numeric function 196
STANDARDIZE statistical function 289
statistical function

AVEDEV 230
AVERAGE 231
AVERAGEA 232
AVERAGEIF 233, 360
AVERAGEIFS 234, 360
BETADIST 236
BETAINV 237
BINOMDIST 238
CHIDIST 239
CHIINV 239
CHITEST 240
CONFIDENCE 242
CORREL 242, 363
COUNT 244, 363
COUNTA 245, 363
COUNTBLANK 246, 363
COUNTIF 247, 360, 363
COUNTIFS 248, 360