【正文】 MT ____________________________________________________________________ 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 _____________________________________________________________ 62 6 TODAY___________________________________________________________________ 63 6 WEEKDAY _______________________________________________________________ 63 70、 WEEKNUM ______________________________________________________________ 64 7 WORKDAY _______________________________________________________________ 64 7 YEAR ____________________________________________________________________ 65 7 YEARFRAC ______________________________________________________________ 66 第三章 數(shù)學(xué)和 三角函數(shù) ____________________________________________________ 67 7 ABS ______________________________________________________________________ 67 7 ACOS ____________________________________________________________________ 67 7 ACOSH __________________________________________________________________ 68 7 ASIN _____________________________________________________________________ 68 7 ASINH ___________________________________________________________________ 68 7 ATAN ____________________________________________________________________ 69 80、 ATAN2 ___________________________________________________________________ 69 8 ATANH ___________________________________________________________________ 69 8 CEILING _________________________________________________________________ 70 8 COMBIN _________________________________________________________________ 70 8 COS _____________________________________________________________________ 71 8 COSH ____________________________________________________________________ 71 8 DEGREES ________________________________________________________________ 72 8 EVEN ____________________________________________________________________ 72 8 EXP______________________________________________________________________ 73 8 FACT ____________________________________________________________________ 73 90、 FACTDOUBLE ____________________________________________________________ 73 9 FLOOR _________________________________________________________