【正文】 ..............…................. 12 2 INTRATE................................................................................................................................……............... 13 2 IPMT........................................................................................................................................……............... 13 2 IRR...........................................................................................................................................……............... 13 2 ISPMT.....................................................................................................................................……................ 13 2 MDURATION .......................................................................................................................…..................... 13 2 MIRR......................................................................................................................................……................. 13 2 .NOMINAL..............................................................................................................................… .................... 13 2 NPER.......................................................................................................................................……................. 13 2 NPV.............................................................................................................................................…….............. 13 ODDFPRICE ..............................................................................................................................…................. 13 3 ODDFYIELD .....................................................................................................…....................... .................. 14 3 ODDLPRICE .....................................................................................................…......................................... 14 3 ODDLYIELD ......................................................................................................…...................... .................. 14 3 PMT.......................................................................................................................…….................................. 14 3 PPMT......................................................................................................................… …................................. 14 3 PRICE......................................................................................................................……..... ........................... 14 3 PRICEDISC ............................................................................................................…................................... 14 3 PRICEMAT ...............................................................................................................…............. .................... 15 3 PV................................................................................................................................……............................ 15 RATE............................................................................................................................…............................ 15 4 RECEIVED ................................................................................................................................................. 15 4 SLN................................................................................................................................….......................... 15 4 SYD.................................................................................................................................…......................... 15 4 TBILLEQ..........................................................................................................................…... ..................... 15 4 TBILLPRICE .....................................................................................................................…............ ........... 15 4 TBILLYIELD ..................................................................................................................….......................... 15 4 VDB.................................................................................................................................….......................... 15 4 XIRR...............................................................................................................................….......................... 16 4 XNPV..............................................................................................................................… ........................... 16 50、 YIELD.............................................................................................................................….......................... 16 5 YIELDDISC ...................................................................................................................….......................... 16 5 YIELDMAT ............................................................................................................................. .................... 16 (六 )、 信息函數(shù) .................................................................................................................................... .............. 16 CELL...........................................................................................................................…................................ 16 ..................................................................................................................….......... ................. 16 INFO.........................................................................................................................