Microsoft Excel Functions

CHAPTER 1 Functions Overview - Page 20
CHAPTER 1 Functions Overview - Page 21
CHAPTER 1 Functions Overview - Page 22
Database- and List-Management Functions - Page 23
DDE and External Functions - Page 24
DDE and External Functions - Page 25
Financial Functions - Page 26
Financial Functions - Page 27
Financial Functions - Page 28
Financial Functions - Page 29
Logical Functions - Page 30
Math and Trigonometry Functions - Page 31
Math and Trigonometry Functions - Page 32
Statistical Functions - Page 33
Statistical Functions - Page 34
Statistical Functions - Page 35
Text Functions - Page 36
Text Functions - Page 37
CHAPTER 2 Managing Your Business with Functions - Page 38
Using Functions for Lookup and Reference, Math, and Trigonometry - Page 39
Using Functions for Lookup and Reference, Math, and Trigonometry - Page 40
Working with Date and Time - Page 41
Computing Statistics - Page 42
Generating Financial Results - Page 43
Generating Financial Results - Page 44
Producing Logical and Informational Data - Page 45
Working with Text - Page 46
Important Tools for Any Business - Page 47
Important Tools for Any Business - Page 48
Important Tools for Any Business - Page 49
Important Tools for Any Business - Page 50
Important Tools for Any Business - Page 51
Important Tools for Any Business - Page 52
Important Tools for Any Business - Page 53
Important Tools for Any Business - Page 54
Important Tools for Any Business - Page 55
Important Tools for Any Business - Page 56
Important Tools for Any Business - Page 57
Important Tools for Any Business - Page 58
Important Tools for Any Business - Page 59
Important Tools for Any Business - Page 60
Important Tools for Any Business - Page 61
Important Tools for Any Business - Page 62
Important Tools for Any Business - Page 63
Important Tools for Any Business - Page 64
Important Tools for Any Business - Page 65
Important Tools for Any Business - Page 66
Important Tools for Any Business - Page 67
CHAPTER 3 Database- and List-Management Functions - Page 68
DAVERAGE - Page 69
DCOUNT - Page 70
DCOUNTA - Page 71
DMAX - Page 72
DMIN - Page 73
DSTDEV - Page 74
DSUM - Page 75
DVAR - Page 76
DVARP - Page 77
GETPIVOTDATA - Page 78
GETPIVOTDATA - Page 79
CHAPTER 4 Date and Time Functions - Page 80
DATE - Page 81
DAY - Page 82
DAYS360 - Page 83
EOMONTH - Page 84
HOUR - Page 85
MONTH - Page 86
NETWORKDAYS - Page 87
NOW - Page 88
TIME - Page 89
WEEKDAY - Page 90
WEEKNUM - Page 91
WORKDAY - Page 92
YEARFRAC - Page 93
CHAPTER 5 Engineering Functions - Page 94
BESSELI - Page 95
BESSELK - Page 96
BESSELY - Page 97
BIN2DEC - Page 98
BIN2HEX - Page 99
COMPLEX - Page 100
CONVERT - Page 101
CONVERT - Page 102
CONVERT - Page 103
DEC2BIN - Page 104
DEC2HEX - Page 105
ERF - Page 106
ERFC - Page 107
HEX2BIN - Page 108
HEX2DEC - Page 109
IMABS - Page 110
IMAGINARY - Page 111
IMARGUMENT - Page 112
IMCOS - Page 113
IMDIV - Page 114
IMEXP - Page 115
IMLN - Page 116
IMLOG2 - Page 117
IMPOWER - Page 118
IMPRODUCT - Page 119
IMREAL - Page 120
IMSIN - Page 121
IMSUB - Page 122
IMSUM - Page 123
OCT2BIN - Page 124
OCT2DEC - Page 125
OCT2DEC - Page 126
OCT2DEC - Page 127
CHAPTER 6 Financial Functions - Page 128
ACCRINT - Page 129
ACCRINTM - Page 130
AMORLINC - Page 131
COUPDAYBS - Page 132
COUPDAYS - Page 133
COUPDAYSNC - Page 134
COUPNUM - Page 135
COUPPCD - Page 136
CUMIPMT - Page 137
DB - Page 138
DDB - Page 139
DISC - Page 140
DOLLARDE - Page 141
DURATION - Page 142
FV - Page 143
FVSCHEDULE - Page 144
IPMT - Page 145
IRR - Page 146
ISPMT - Page 147
MIRR - Page 148
NOMINAL - Page 149
NPV - Page 150
ODDFPRICE - Page 151
ODDFPRICE - Page 152
ODDFYIELD - Page 153
ODDLYIELD - Page 154
PMT - Page 155
PRICE - Page 156
PRICEDISC - Page 157
PRICEMAT - Page 158
PV - Page 159
RATE - Page 160
RECEIVED - Page 161
SLN - Page 162
SYD - Page 163
TBILLPRICE - Page 164
TBILLYIELD - Page 165
VDB - Page 166
XIRR - Page 167
YIELD - Page 168
YIELDDISC - Page 169
YIELDMAT - Page 170
YIELDMAT - Page 171
CHAPTER 7 Information Functions - Page 172
CELL - Page 173
CELL - Page 174
COUNTBLANK - Page 175
ERROR.TYPE - Page 176
INFO - Page 177
IS Functions - Page 178
Using the ISBLANK Function - Page 179
N - Page 180
NA - Page 181
CHAPTER 8 Logical Functions - Page 182
AND - Page 183
FALSE - Page 184
IF - Page 185
NOT - Page 186
OR - Page 187
CHAPTER 9 Lookup and Reference Functions - Page 188
ADDRESS - Page 189
CHOOSE - Page 190
COLUMN - Page 191
COLUMNS - Page 192
HYPERLINK - Page 193
INDEX (Array Form) - Page 194
INDEX (Reference Form) - Page 195
INDEX (Reference Form) - Page 196
INDIRECT - Page 197
LOOKUP (Array Form) - Page 198
LOOKUP (Vector Form) - Page 199
OFFSET - Page 200
OFFSET - Page 201
OFFSET - Page 202
ROW - Page 203
VLOOKUP - Page 204
VLOOKUP - Page 205
CHAPTER 10 Math and Trigonometry Functions - Page 206
ABS - Page 207
ACOSH - Page 208
ASINH - Page 209
ATAN - Page 210
ATANH - Page 211
CEILING - Page 212
COS - Page 213
COSH - Page 214
DEGREES - Page 215
EVEN - Page 216
FACT - Page 217
FACTDOUBLE - Page 218
GCD - Page 219
LCM - Page 220
LOG - Page 221
MINVERSE - Page 222
MOD - Page 223
ODD - Page 224
PI - Page 225
QUOTIENT - Page 226
RAND - Page 227
ROMAN - Page 228
ROUNDDOWN - Page 229
SIGN - Page 230
SINH - Page 231
SUBTOTAL - Page 232
SUM - Page 233
SUMIF - Page 234
SUMPRODUCT - Page 235
SUMSQ - Page 236
SUMX2MY2 - Page 237
TAN - Page 238
TAN - Page 239
CHAPTER 11 Statistical Functions - Page 240
AVEDEV - Page 241
AVERAGEA - Page 242
BETAINV - Page 243
BETAINV - Page 244
CHIDIST - Page 245
CHITEST - Page 246
CORREL - Page 247
COUNT - Page 248
COUNTA - Page 249
COUNTIF - Page 250
COVAR - Page 251
DEVSQ - Page 252
EXPONDIST - Page 253
FDIST - Page 254
FINV - Page 255
FORECAST - Page 256
FTEST - Page 257
GAMMADIST - Page 258
GAMMAINV - Page 259
GROWTH - Page 260
HARMEAN - Page 261
INTERCEPT - Page 262
KURT - Page 263
LINEST - Page 264
LOGEST - Page 265
LOGINV - Page 266
LOGNORMDIST - Page 267
MAXA - Page 268
MIN - Page 269
NEGBINOMDIST - Page 270
NORMDIST - Page 271
NORMINV - Page 272
NORMSDIST - Page 273
PERCENTILE - Page 274
PERCENTRANK - Page 275
PERMUT - Page 276
PROB - Page 277
QUARTILE - Page 278
RANK - Page 279
SKEW - Page 280
SLOPE - Page 281
SMALL - Page 282
STDEV - Page 283
STDEVA - Page 284
STDEVPA - Page 285
TDIST - Page 286
TINV - Page 287
TRIMMEAN - Page 288
TTEST - Page 289
VARA - Page 290
VARPA - Page 291
ZTEST - Page 292
ZTEST - Page 293
CHAPTER 12 Text Functions - Page 294
ASC - Page 295
CLEAN - Page 296
CONCATENATE - Page 297
EXACT - Page 298
FIND - Page 299
FIXED - Page 300
JIS - Page 301
LEN - Page 302
LOWER - Page 303
PHONETIC - Page 304
PROPER - Page 305
REPT - Page 306
SEARCH - Page 307
T - Page 308
TRIM - Page 309
UPPER - Page 310
VALUE - Page 311