Excel函数应用完全手册

Excel2023函数应用完全手册二〇〇四年二月二日目录HYPERLINK一、函数应用基础.........................................................................................................................................1HYPERLINK(一)函数和公式...............................................................................................................................................1HYPERLINK1.什么是函数..............................................................................................................................….................1HYPERLINK2.什么是公式..............................................................................................................................….................1HYPERLINK(二)函数旳参数................................................................................................................................................1HYPERLINK1.常量..........................................................................................................................................…..................1HYPERLINK2.逻辑值..........................................................................................................................................…..............1HYPERLINK3.数组............................................................................................................................................…................1HYPERLINK4.错误值........................................................................................................................................…................1HYPERLINK5.单元格引用...............................................................................................................................….................1HYPERLINK6.嵌套函数.................................................................................................................................…...................2HYPERLINK7.名称和标志........................................................................................................................…........................2HYPERLINK(三)函数输入措施.............................................................................................................................................2HYPERLINK1.“插入函数”对话框...............................................................................................................................…..2HYPERLINK2.编辑栏输入...............................................................................................................................................…..3HYPERLINK二、函数速查一览............................................................................................................................................3HYPERLINK1.DAVERAGE...................................................................................................................................................3HYPERLINK2.DCOUNT...........................................................................................................................................….........3HYPERLINK3.DCOUNTA.........................................................................................................................................….........3HYPERLINK4.DGET..........................................................................................................................................……….........3HYPERLINK5.DMAX..........................................................................................................................................……...........3HYPERLINK6.DMIN............................................................................................................................................……….......3HYPERLINK7.DPRODUCT....................................................................................................................................................3HYPERLINK8.DSTDEV.........................................................................................................................................…….........3HYPERLINK9.DSTDEVP........................................................................................................................................…............4HYPERLINK10.DSUM.............................................................................................................................................……........4HYPERLINK11.DVAR.............................................................................................................................................……….....4HYPERLINK12.DVARP...........................................................................................................................................…….........4HYPERLINK13.GETPIVOTDATA...........................................................................................................................................4HYPERLINK(二)日期与时间函数.......................................................................................................................................4HYPERLINK1.DATE...............................................................................................................................................……..........4HYPERLINK2.DATEVALUE..................................................................................................................................…..............4HYPERLINK3.DAY.................................................................................................................................................……...........4HYPERLINK4.DAYS360.................................................................................................................................……...................5HYPERLINK5.EDATE.....................................................................................................................................…......................5HYPERLINK6.EOMONTH............................................................................................................................…........................5HYPERLINK7.HOUR........................................................................................................................................…....................5HYPERLINK8.MINUTE...................................................................................................................................….....................5HYPERLINK9.MONTH...........................................................................................................................................................5HYPERLINK10.NETWORKDAYS.........................................................................................................................................5HYPERLINK11.NOW........................................................................................................................................…...................6HYPERLINK12.SECOND................................................................................................................................…....................6HYPERLINK13.TIME.......................................................................................................................................…...................6HYPERLINK14.TIMEVALUE................................................................................................................................................6HYPERLINK15.TODAY....................................................................................................................................…...................6HYPERLINK16.WEEKDAY.....................................................................................................................................................6HYPERLINK17.WEEKNUM....................................................................................................................................................6HYPERLINK18.WORKDAY.....................................................................................................................................................6HYPERLINK19.YEAR......................................................................................................................................…....................7HYPERLINK20.YEARFRAC...................................................................................................................................................7HYPERLINK(三)外部函数.....................................................................................................................................................7HYPERLINK1.EUROCONVERT..............................................................................................................................................7HYPERLINK........................................................................................................................….....................7HYPERLINK(四)工程函数.....................................................................................................................................................7HYPERLINK1.BESSELI.......................................................................................................................................……..............7HYPERLINK2.BESSELJ........................................................................................................................................…….............8HYPERLINK3.BESSELK.............................................................................................................................…….......................8HYPERLINK4.BESSELY......................................................................................................................................……...............8HYPERLINK5.BIN2DEC....................................................................................................................................…….................8HYPERLINK6.BIN2HEX..................................................................................................................................……...................8HYPERLINK7.BIN2OCT...................................................................................................................................……...................8HYPERLINK8PLEX................................................................................................................................….......................8HYPERLINK9.CONVERT.................................................................................................................................……....................8HYPERLINK10.DEC2BIN................................................................................................................................……....................8HYPERLINK11.DEC2HEX...............................................................................................................................……....................8HYPERLINK12.DEC2OCT.................................................................................................................................……..................8HYPERLINK13.DELTA......................................................................................................................................……..................8HYPERLINK14.ERF...........................................................................................................................................……..................8HYPERLINK15.ERFC........................................................................................................................................…….................9HYPERLINK16.GESTEP....................................................................................................................................……..................9HYPERLINK17.HEX2BIN..................................................................................................................................…….................9HYPERLINK18.HEX2DEC..................................................................................................................................…….................9HYPERLINK19.HEX2OCT..................................................................................................................................…….................9HYPERLINK20.IMABS........................................................................................................................................……................9HYPERLINK21.IMAGINARY..............................................................................................................................…...................9HYPERLINK22.IMARGUMENT.....................................................................................................................…........................9HYPERLINK23.MCONJUGATE.....................................................................................................................…........................9HYPERLINK24.IMCOS.....................................................................................................................................……...................9HYPERLINK25.IMDIV....................................................................................................................................……....................9HYPERLINK26.IMEXP...............................................................................................................................…….........................9HYPERLINK27.IMLN......................................................................................................................................……....................9HYPERLINK28.IMLOG10............................................................................................................................……......................10HYPERLINK29.IMLOG2..............................................................................................................................……......................10HYPERLINK30.IMPOWER...............................................................................................................................……..................10HYPERLINK31.IMPRODUCT.........................................................................................................................…......................10HYPERLINK32.IMREAL......................................................................................................................................…..............10HYPERLINK33.IMSIN..........................................................................................................................................……...........10HYPERLINK34.IMSQRT......................................................................................................................................…...............10HYPERLINK35.IMSUB..........................................................................................................................................….….........10HYPERLINK36.IMSUM..............................................................................................................................................…........10HYPERLINK37.OCT2BIN...........................................................................................................................................…........10HYPERLINK38.OCT2DEC........................................................................................................................................…..........10HYPERLINK39.OCT2HEX........................................................................................................................................…..........10HYPERLINK1.ACCRINT.................................................................................................................................…...................10HYPERLINK2.ACCRINTM.......................................................................................................................…..........................11HYPERLINK3.AMORDEGRC..................................................................................................................…..........................11HYPERLINK4.AMORLINC.......................................................................................................................…..........................11HYPERLINK5.COUPDAYBS.................................................................................................................................................11HYPERLINK6.COUPDAYS........................................................................................................................….........................11HYPERLINK7.COUPDAYSNC...............................................................................................................................................11HYPERLINK8.COUPNUM.........................................................................................................................…..........................11HYPERLINK9.COUPPCD.........................................................................................................................…...........................11HYPERLINK10.CUMIPMT......................................................................................................................…............................11HYPERLINK11.CUMPRINC...................................................................................................................…............................12HYPERLINK12.DB...................................................................................................................................……........................12HYPERLINK13.DDB....................................................................................................................................…….....................12HYPERLINK14.DISC..........................................................................................................................................……..............12HYPERLINK15.DOLLARDE............................................................................................................................…...................12HYPERLINK16.DOLLARFR............................................................................................................................…...................12HYPERLINK17.DURATION.............................................................................................................................…...................12HYPERLINK18.EFFECT....................................................................................................................................……...............12HYPERLINK19.FV..................................................................................................................................................……..........12HYPERLINK20.FVSCHEDULE..........................................................................................................................….................12HYPERLINK21.INTRATE..................................................................................................................................……...............13HYPERLINK22.IPMT.........................................................................................................................................……...............13HYPERLINK23.IRR............................................................................................................................................……...............13HYPERLINK24.ISPMT......................................................................................................................................……................13HYPERLINK25.MDURATION........................................................................................................................….....................13HYPERLINK26.MIRR.......................................................................................................................................…….................13HYPERLINK27.NOMINAL..............................................................................................................................….....................13HYPERLINK28.NPER.......................................................................................................................................…….................13HYPERLINK29.NPV.............................................................................................................................................……..............13HYPERLINK30.ODDFPRICE..............................................................................................................................….................13HYPERLINK31.ODDFYIELD.....................................................................................................….........................................14HYPERLINK32.ODDLPRICE.....................................................................................................….........................................14HYPERLINK33.ODDLYIELD......................................................................................................…........................................14HYPERLINK34.PMT.......................................................................................................................……..................................14HYPERLINK35.PPMT......................................................................................................................…….................................14HYPERLINK36.PRICE......................................................................................................................……................................14HYPERLINK37.PRICEDISC............................................................................................................…...................................14HYPERLINK38.PRICEMAT...............................................................................................................….................................15HYPERLINK39.PV................................................................................................................................……............................15HYPERLINK40.RATE............................................................................................................................…............................15HYPERLINK41.RECEIVED.................................................................................................................................................15HYPERLINK42.SLN................................................................................................................................…..........................15HYPERLINK43.SYD.................................................................................................................................….........................15HYPERLINK44.TBILLEQ..........................................................................................................................…........................15HYPERLINK45.TBILLPRICE.....................................................................................................................….......................15HYPERLINK46.TBILLYIELD..................................................................................................................…..........................15HYPERLINK47.VDB.................................................................................................................................…..........................15HYPERLINK48.XIRR...............................................................................................................................…..........................16HYPERLINK49.XNPV..............................................................................................................................…...........................16HYPERLINK50.YIELD.............................................................................................................................…..........................16HYPERLINK51.YIELDDISC...................................................................................................................…..........................16HYPERLINK52.YIELDMAT.................................................................................................................................................16HYPERLINK(六)信息函数....................................................................................................................