36.IMSUM....................................................................................................................................................... 10
37.OCT2BIN................................................................................................................................................... 10
38.OCT2DEC................................................................................................................................................... 10
39.OCT2HEX................................................................................................................................................... 10
(五)财务函数........................................................................................................................................................ 10
1.ACCRINT..................................................................................................................................................... 10
2.ACCRINTM................................................................................................................................................... 11
3.AMORDEGRC................................................................................................................................................. 11
4.AMORLINC................................................................................................................................................... 11
5.COUPDAYBS................................................................................................................................................. 11
6.COUPDAYS................................................................................................................................................... 11
7.COUPDAYSNC............................................................................................................................................... 11
8.COUPNUM..................................................................................................................................................... 11
9.COUPPCD..................................................................................................................................................... 11
10.CUMIPMT................................................................................................................................................... 11
11.CUMPRINC................................................................................................................................................. 12
12.DB............................................................................................................................................................. 12
13.DDB........................................................................................................................................................... 12
14.DISC......................................................................................................................................................... 12
15.DOLLARDE................................................................................................................................................. 12
16.DOLLARFR................................................................................................................................................. 12
17.DURATION................................................................................................................................................. 12
18.EFFECT..................................................................................................................................................... 12
19.FV............................................................................................................................................................. 12
20.FVSCHEDULE............................................................................................................................................. 12
21.INTRATE................................................................................................................................................... 13
22.IPMT......................................................................................................................................................... 13
23.IRR........................................................................................................................................................... 13
24.ISPMT....................................................................................................................................................... 13
25.MDURATION............................................................................................................................................... 13
26.MIRR......................................................................................................................................................... 13
27.NOMINAL................................................................................................................................................... 13
28.NPER......................................................................................................................................................... 13
29.NPV........................................................................................................................................................... 13
30.ODDFPRICE............................................................................................................................................... 13
31.ODDFYIELD............................................................................................................................................... 14
32.ODDLPRICE............................................................................................................................................... 14
33.ODDLYIELD............................................................................................................................................... 14
34.PMT........................................................................................................................................................... 14
35.PPMT......................................................................................................................................................... 14
36.PRICE....................................................................................................................................................... 14
37.PRICEDISC............................................................................................................................................... 14
38.PRICEMAT................................................................................................................................................. 15
4
39.PV............................................................................................................................................................. 15
40.RATE......................................................................................................................................................... 15
41.RECEIVED................................................................................................................................................. 15
42.SLN........................................................................................................................................................... 15
43.SYD........................................................................................................................................................... 15
44.TBILLEQ................................................................................................................................................... 15
45.TBILLPRICE............................................................................................................................................. 15
46.TBILLYIELD............................................................................................................................................. 15
47.VDB........................................................................................................................................................... 15
48.XIRR......................................................................................................................................................... 16
49.XNPV......................................................................................................................................................... 16
50.YIELD....................................................................................................................................................... 16
51.YIELDDISC............................................................................................................................................... 16
52.YIELDMAT................................................................................................................................................. 16
(六)信息函数........................................................................................................................................................ 16
1.CELL........................................................................................................................................................... 16
2.ERROR.TYPE............................................................................................................................................... 16
3.INFO........................................................................................................................................................... 16
4.IS 类函数.................................................................................................................................................. 17
5.ISEVEN....................................................................................................................................................... 17
6.ISODD......................................................................................................................................................... 17
7.N................................................................................................................................................................. 17
8.NA............................................................................................................................................................... 17
9.TYPE........................................................................................................................................................... 18
(七)逻辑运算符.................................................................................................................................................... 18
1.AND............................................................................................................................................................. 18
2.FALSE......................................................................................................................................................... 18
3.IF............................................................................................................................................................... 18
4.NOT............................................................................................................................................................. 18
5.OR............................................................................................................................................................... 18
6.TRUE........................................................................................................................................................... 18
(八)查找和引用函数............................................................................................................................................ 19
1.ADDRESS..................................................................................................................................................... 19
2.AREAS......................................................................................................................................................... 19
3.CHOOSE....................................................................................................................................................... 19
4.COLUMN....................................................................................................................................................... 19
5.COLUMNS..................................................................................................................................................... 19
6.HLOOKUP..................................................................................................................................................... 19
7.HYPERLINK................................................................................................................................................. 19
8.INDEX......................................................................................................................................................... 20
9.INDIRECT................................................................................................................................................... 20
10.LOOKUP..................................................................................................................................................... 20
11.MATCH....................................................................................................................................................... 20
12.OFFSET..................................................................................................................................................... 21
13.ROW........................................................................................................................................................... 21
14.ROWS......................................................................................................................................................... 21
5
15.RTD........................................................................................................................................................... 21
16.TRANSPOSE............................................................................................................................................... 21
