Excel函数用途、参数、用法速查表【优秀范文】

下面是小编为大家整理的Excel函数用途、参数、用法速查表【优秀范文】,供大家参考。

　l Excel 函数应用教程

　目录

　逻辑函数 .................................................................................................................................................................................. 8 1.AND ............................................................................................................................................................................... 8 2.FALSE ........................................................................................................................................................................... 8 3.IF .................................................................................................................................................................................... 8 4.NOT ............................................................................................................................................................................... 8 5.OR .................................................................................................................................................................................. 8 6.TRUE ............................................................................................................................................................................ 8 信息函数 .................................................................................................................................................................................. 8 1.CELL ............................................................................................................................................................................. 8 2.ERROR.TYPE .............................................................................................................................................................. 9 3.INFO .............................................................................................................................................................................. 9 4.IS 类函数 ....................................................................................................................................................................... 9 5.ISEVEN ......................................................................................................................................................................... 9 6.ISODD ........................................................................................................................................................................... 9 7.N ..................................................................................................................................................................................... 9 8.NA ................................................................................................................................................................................ 10 9.TYPE ........................................................................................................................................................................... 10 财务函数 ................................................................................................................................................................................ 10 1.ACCRINT ................................................................................................................................................................... 10 2.ACCRINTM ............................................................................................................................................................... 10 3.AMORDEGRC ........................................................................................................................................................... 10 4.AMORLINC ............................................................................................................................................................... 10 5.COUPDAYBS ............................................................................................................................................................. 10 6.COUPDAYS ................................................................................................................................................................ 10 7.COUPDAYSNC .......................................................................................................................................................... 11 8.COUPNUM ................................................................................................................................................................. 11 9.COUPPCD .................................................................................................................................................................. 11 10.CUMIPMT ................................................................................................................................................................ 11 11.CUMPRINC .............................................................................................................................................................. 11 12.DB .............................................................................................................................................................................. 11 13.DDB ........................................................................................................................................................................... 11 14.DISC .......................................................................................................................................................................... 11 15.DOLLARDE ............................................................................................................................................................. 11 16.DOLLARFR ............................................................................................................................................................. 11 17.DURATION .............................................................................................................................................................. 12 18.EFFECT .................................................................................................................................................................... 12 19.FV .............................................................................................................................................................................. 12 20.FVSCHEDULE ........................................................................................................................................................ 12 21.INTRATE .................................................................................................................................................................. 12 22.IPMT ......................................................................................................................................................................... 12 23.IRR ............................................................................................................................................................................ 12 24.ISPMT ....................................................................................................................................................................... 12 25.MDURATION .......................................................................................................................................................... 12 26.MIRR ........................................................................................................................................................................ 12 27.NOMINAL ................................................................................................................................................................ 13 28.NPER ......................................................................................................................................................................... 13 29.NPV ........................................................................................................................................................................... 13

　30.ODDFPRICE ............................................................................................................................................................ 13 31.ODDFYIELD ............................................................................................................................................................ 13 32.ODDLPRICE ............................................................................................................................................................ 13 33.ODDLYIELD ............................................................................................................................................................ 13 34.PMT ........................................................................................................................................................................... 13 35.PPMT ........................................................................................................................................................................ 13 36.PRICE ....................................................................................................................................................................... 14 37.PRICEDISC .............................................................................................................................................................. 14 38.PRICEMAT .............................................................................................................................................................. 14 39.PV .............................................................................................................................................................................. 14 4...