Apple iWork '09 - Manual (Page 367)

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
financial function
ACCRINT 99, 351
ACCRINTM 101
BONDDURATION 103
BONDMDURATION 104
COUPDAYBS 105
COUPDAYS 107
COUPDAYSNC 108
COUPNUM 109, 351
CUMIPMT 110
CUMPRINC 112
DB 114, 352
DDB 116, 352
DISC 117, 351
EFFECT 119, 351
FV 120, 348, 351
INTRATE 122, 352
IPMT 123, 353
IRR 125, 350
ISPMT 126
MIRR 128, 350
NOMINAL 129, 351
NPER 130, 348, 351
NPV 132, 350
PMT 134, 348, 351, 353
PPMT 135, 353
PRICE 137, 352
PRICEDISC 138
PRICEMAT 140
PV 349
RATE 144, 349
RECEIVED 146, 352
SLN 147, 352
SYD 148, 352
VDB 149, 352
YIELD 150, 352
YIELDDISC 152
YIELDMAT 153
financial function argument defined
annual-rate 341
annual-yield 341
cash-flow 341
cost 341
cum-when-due 342, 347
days-basis 342
depr-factor 342
depr-period 343
effective-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
finding and replacing
formula elements 32
text strings 312, 314, 316, 318, 319, 320
FIXED mathematical function 313
FLOOR numeric function 176, 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
finding and replacing elements of 32