Formulas and Functions

Index 367
DEC2OCT 85
DELTA 86
ERF 87
ERFC 87
GESTEP 88
HEX2BIN 89
HEX2DEC 90
HEX2OCT 91
NUMTOBASE 92
OCT2BIN 93
OCT2DEC 94
OCT2HEX 95
EOMONTH date and time function 51
ERF engineering function 87
ERFC engineering function 87
European days-basis 342
EVEN numeric function 173, 355
EXACT text function 312
EXP numeric function 174
F
FACT numeric function 174
FACTDOUBLE numeric function 175
FALSE logical and information function 157
FDIST statistical function 254, 255, 261
nancial function
ACCRINT 99, 351
ACCRINTM 101
BONDDURATION 103
BONDMDURATION 104
COUPDAYBS 105
COUPDAYS 107
COUPDAYSNC 108
COUPNUM 109, 351
CUMIPMT 110
CUMPRINC 11 2
DB 11 4, 352
DDB 116, 352
DISC 11 7, 351
EFFECT 11 9, 351
FV 12 0, 348, 351
INTRATE 12 2, 352
IPMT 12 3, 353
IRR 12 5, 350
ISPMT 12 6
MIRR 12 8, 350
NOMINAL 12 9, 351
NPER 13 0, 348, 351
NPV 132, 350
PMT 13 4, 348, 351, 353
PPMT 135, 353
PRICE 137, 352
PRICEDISC 13 8
PRICEMAT 140
PV 349
RATE 144, 349
RECEIVED 146, 352
SLN 147, 352
SYD 148, 352
VDB 149, 352
YIELD 15 0, 352
YIELDDISC 152
YIELDMAT 153
nancial function argument dened
annual-rate 341
annual-yield 341
cash-ow 341
cost 341
cum-when-due 342, 347
days-basis 342
depr-factor 342
depr-period 343
eective-int-rate 343
end-per 343, 347
estimate 343
European days-basis 342
frequency 343
future-value 344
invest-amount 344
life 344
NASD days-basis 342
nominal-rate 344
num-periods 344
num-periodsyear 345
par 345
payment 345
period 345
periodic-discount-rate 345
periodic-rate 346
present-value 346
price 346
redemption 346
salvage 347
start-per 343, 347
when-due 347
FIND text function 312
nding and replacing
formula elements 32
text strings 312, 314, 316, 318, 319, 320
FIXED mathematical function 313
FLOOR numeric function 17 6, 355
force conversion units 81
FORECAST statistical function 256
formula bar 20
Formula Editor 19
formulas. See also operators; See also functions
adding a quick formula 18
copying and moving 30
creating 19
deleting 24
elements of 15
nding and replacing elements of 32