Excel 公式释义及示例大全（2010 版）
- II -
目 录
ACCRINT 函数 .............................................................................................................................................................. 1
ACCRINTM 函数 ........................................................................................................................................................... 2
AMORDEGRC 函数 ....................................................................................................................................................... 3
AMORLINC 函数 ........................................................................................................................................................... 4
COUPDAYBS 函数 ......................................................................................................................................................... 5
COUPDAYS 函数 ........................................................................................................................................................... 6
COUPDAYSNC 函数 ...................................................................................................................................................... 7
COUPNCD 函数 ............................................................................................................................................................ 8
COUPNUM 函数 ........................................................................................................................................................... 9
COUPPCD 函数........................................................................................................................................................... 10
CUMIPMT 函数 .......................................................................................................................................................... 11
CUMPRINC 函数......................................................................................................................................................... 12
DB 函数 ...................................................................................................................................................................... 13
DDB 函数 ................................................................................................................................................................... 14
DISC 函数 ................................................................................................................................................................... 15
DOLLARDE 函数 ......................................................................................................................................................... 16
DOLLARFR 函数 .......................................................................................................................................................... 17
DURATION 函数 ......................................................................................................................................................... 18
EFFECT 函数 ............................................................................................................................................................... 19
FV 函数 ...................................................................................................................................................................... 20
FVSCHEDULE 函数 ..................................................................................................................................................... 21
INTRATE 函数 ............................................................................................................................................................. 22
IPMT 函数 .................................................................................................................................................................. 23
IRR 函数 ..................................................................................................................................................................... 24
ISPMT 函数 ................................................................................................................................................................ 25
MDURATION 函数 ...................................................................................................................................................... 26
MIRR 函数 .................................................................................................................................................................. 27
NOMINAL 函数 .......................................................................................................................................................... 28
NPER 函数 .................................................................................................................................................................. 29
NPV 函数 .................................................................................................................................................................... 30
ODDFPRICE 函数 ........................................................................................................................................................ 31
ODDFYIELD 函数 ........................................................................................................................................................ 33
ODDLPRICE 函数 ........................................................................................................................................................ 34
ODDLYIELD 函数 ......................................................................................................................................................... 35
PMT 函数 ................................................................................................................................................................... 37
PPMT 函数 ................................................................................................................................................................. 38
PRICE 函数 ................................................................................................................................................................. 39
PRICEDISC 函数 .......................................................................................................................................................... 40
PRICEMAT 函数 .......................................................................................................................................................... 41
PV 函数 ...................................................................................................................................................................... 42
RATE 函数 .................................................................................................................................................................. 43
RECEIVED 函数 ........................................................................................................................................................... 44
SLN 函数 .................................................................................................................................................................... 45
SYD 函数 .................................................................................................................................................................... 46
TBILLEQ 函数 ............................................................................................................................................................. 47