【正文】 Excel 2020 函數(shù)大全 HuXunmiao 1 EXCEL 2020 函數(shù)大全Excel 2020 函數(shù)大全 HuXunmiao 2 第一章 財(cái)務(wù)函數(shù) ___________________________________________________________ 1 ACCRINT ___________________________________________________________________ 1 ACCRINTM _________________________________________________________________ 2 AMORDEGRC _______________________________________________________________ 3 AMORLINC _________________________________________________________________ 4 COUPDAYBS ________________________________________________________________ 5 COUPDAYS__________________________________________________________________ 6 COUPDAYSNC_______________________________________________________________ 7 COUPNCD __________________________________________________________________ 8 COUPNUM __________________________________________________________________ 9 COUPPCD ________________________________________________________________ 10 1 CUMIPMT _______________________________________________________________ 11 1 CUMPRINC ______________________________________________________________ 12 1 DB _______________________________________________________________________ 13 1 DDB _____________________________________________________________________ 13 1 DISC _____________________________________________________________________ 14 1 DOLLARDE ______________________________________________________________ 15 1 DOLLARFR ______________________________________________________________ 16 1 DURATION _______________________________________________________________ 16 1 EFFECT __________________________________________________________________ 17 FV _______________________________________________________________________ 18 2 FVSCHEDULE ____________________________________________________________ 19 2 INTRATE_________________________________________________________________ 20 2 IPMT ____________________________________________________________________ 21 2 IRR ______________________________________________________________________ 22 2 ISPMT ___________________________________________________________________ 22 2 MDURATION _____________________________________________________________ 23 2 MIRR ____________________________________________________________________ 24 2 NOMINAL________________________________________________________________ 25 2 NPER ____________________________________________________________________ 26 NPV _____________________________________________________________________ 26 3 ODDFPRICE______________________________________________________________ 28 Excel 2020 函數(shù)大全 HuXunmiao 3 3 ODDFYIELD _____________________________________________________________ 30 3 ODDLPRICE _____________________________________________________________ 31 3 ODDLYIELD______________________________________________________________ 33 3 PMT _____________________________________________________________________ 34 3 PPMT ____________________________________________________________________ 35 3 PRICE ___________________________________________________________________ 36 3 PRICEDISC ______________________________________________________________ 38 3 PRICEMAT _______________________________________________________________ 39 PV _______________________________________________________________________ 40 4 RATE ____________________________________________________________________ 42 4 RECEIVED _______________________________________________________________ 43 4 SLN ______________________________________________________________________ 44 4 SYD______________________________________________________________________ 44 4 TBILLEQ ________________________________________________________________ 45 4 TBILLPRICE _____________________________________________________________ 46 4 TBILLYIELD _____________________________________________________________ 46 4 VDB _____________________________________________________________________ 47 4 XIRR ____________________________________________________________________ 48 50、 XNPV ____________________________________________________________________ 49 5 YIELD ___________________________________________________________________ 50 5 YIELDDISC ______________________________________________________________ 52 5 YIELDMAT _______________________________________________________________ 53 第二章 日期和時(shí)間函數(shù) ____________________________________________________ 54 5 DATE ____________________________________________________________________ 54 5 DATEVALUE _____________________________________________________________ 55 5 DAY _____________________________________________________________________ 56 5 DAYS360 _________________________________________________________________ 56 5 EDATE ___________________________________________________________________ 57 5 EOMONTH _______________________________________________________________ 58 60、 HOUR____________________________________________________________________ 58 6 MINUTE _________________________________________________________________ 59 6 MONTH __________________________________________________________________ 59 6 NETWORKDAYS _________________________________________________________ 60 Excel 2020 函數(shù)大全 HuXunmiao 4 6 NOW_____________________________________________________________________ 61 6 SECOND _________________________________________________________________ 61 6 TIME ____________________________________________________________________ 62 6 TIMEVALUE _______________