Formulas and Functions

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 nancial function 13 4, 348, 351, 353
POISSON statistical function 282
power conversion units 82
POWER numeric function 186
PPMT nancial function 13 5, 349, 353
pressure conversion units 81
PRICE nancial function 13 7, 352
PRICEDISC nancial function 13 8
PRICEMAT nancial function 140
PROB statistical function 282
PRODUCT numeric function 187
PROPER text function 317
PV nancial 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 nancial function 14 4, 349
RECEIVED nancial function 14 6, 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 19 0
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 nancial questions 351
search expressions 361
SEARCH text function 320, 361
searching for formulas. See nding and replacing
SECOND date and time function 56
semicolons as argument separators 34
SIGN numeric function 19 5
SIN trigonometric function 336
SINH trigonometric function 337
SLN nancial function 147, 352
SLOPE statistical function 287
SMALL statistical function 288
solving common nancial questions 351
speed conversion units 81
spreadsheets
nding and replacing formula elements 32
viewing all formulas in 31
SQRT numeric function 19 5
SQRTPI numeric function 19 6
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