Formulas and Functions

Index
365
Index
Symbols
? wildcard 30, 361
* wildcard 30, 361
& string operator 30, 310
~ wildcard escape character 30, 361
A
ABS numeric function 17 0
absolute cell references 27
ACCRINT nancial function 99, 351
ACCRINTM nancial function 101
ACOS trigonometric function 327
ACOSH trigonometric function 328
ADDRESS reference function 207
ampersand string operator 30, 310
AND logical and information function 15 6, 358
any value type 36
AREAS reference function 209
arithmetic operators 28
array constant 35
array dened 35
array function
dened 35
FREQUENCY 257
INDEX 214
INDIRECT 216
LINEST 265
OFFSET 219
TRANSPOSE 222
ASIN trigonometric function 329
ASINH trigonometric function 329
asterisk wildcard 30, 361
ATAN trigonometric function 330
ATAN2 trigonometric function 331
ATANH trigonometric function 332
AVEDEV statistical function 230
AVERAGE statistical function 231
AVERAGEA statistical function 232
AVERAGEIF statistical function 233, 360
AVERAGEIFS statistical function 234, 360
B
BASETONUM engineering function 73
BESSELJ engineering function 74
BESSELY engineering function 75
BETADIST statistical function 236
BETAINV statistical function 237
BIN2DEC engineering function 76
BIN2HEX engineering function 77
BIN2OCT engineering function 78
BINOMDIST statistical function 238
bond investment related nancial questions 351
BONDDURATION nancial function 103
BONDMDURATION nancial function 104
Boolean expression dened 35
Boolean value type 36
C
calculations, instant 17
CEILING numeric function 17 0, 355
cell comments example 358
cell references
distinguishing absolute and relative 27
inserting into formulas 26
CHAR text function 308
CHIDIST statistical function 239
CHIINV statistical function 239
CHITEST statistical function 240
CHOOSE reference function 209
choosing which TVM function to use 348
CLEAN text function 308
CODE text function 309
collection value type 36
colon as reference element separator 39
COLUMN reference function 210
COLUMNS reference function 211
COMBIN numeric function 172
commas as argument separators 34
common arguments used in nancial functions 341
comparison operators 29
CONCATENATE text function 310
condition 30
comparison operators 29
dened 35
specifying 360
CONFIDENCE statistical function 242
Index
Index