Page 477 - Excel for Scientists and Engineers: Numerical Methods

454 EXCELNJMERICAL METHODS

second derivative of 12 1
worksheet functions:
ABS 256,279
COLUMN 256,259,278,279
HLOOKUP 77
IF 278,279
INDEX 80,81,84, 106,346,349
INDIRECT 72, 107,279,256,259
INTERCEPT 289,291
ISERROR 360
LINEST 65, 105,292,293,294,296,
297
LOOKUP 79
MATCH 80,84, 106, 107,346
MAX 80,279
MDETERM 60,63, 190, 191
MIDENT 63
MIN 279
Mlndex 64
MINVERSE 60, 191,257,261,276
MMULT 62, 191,257,261,276
MSCALE 64
NORMINV 349
OFFSET 106
RAND 342,343,345
RANDBETWEEN 343
ROUND 343
ROW 71, 107,256,259,279,347
RSQ 289,291
SLOPE 289,291
SMALL 346
SUBSTITUTE 116,134,225
TRANSPOSE 49
TREND 85,86,90
VLOOKUP 77,79,80,81
worksheet functions with VBA 23