Excel+2003常用函數(shù)完全手冊.doc

Excel 2003 函數(shù)應(yīng)用完全手冊 二四年二月二日目 錄 一、函數(shù)應(yīng)用基礎(chǔ). 1 (一)函數(shù)和公式. 1 1.什么是函數(shù). 1 2.什么是公式. 1 (二)函數(shù)的參數(shù). 1 1.常量. 1 2.邏輯值. 1 3.數(shù)組. 1 4.錯誤值. 1 5.單元格引用. 1 6.嵌套函數(shù). 2 7.名稱和標(biāo)志. 2 (三)函數(shù)輸入方法. 2 1.“插入函數(shù)”對話框. 2 2.編輯欄輸入. 3 二、函數(shù)速查一覽. 3 (一)數(shù)據(jù)庫函數(shù). 3 1.DAVERAGE. 3 2.DCOUNT. 33.DCOUNTA. 34.DGET. 35.DMAX. 36.DMIN. 37.DPRODUCT. 38.DSTDEV. 39.DSTDEVP. 410.DSUM. 411.DVAR. 412.DVARP. 413.GETPIVOTDATA. 4(二)日期與時間函數(shù). 4 1.DATE. 4 2.DATEVALUE. 4 3.DAY. 4 4.DAYS360. 5 5.EDATE. 5 6.EOMONTH. 5 7.HOUR. 5 8.MINUTE. 5 9.MONTH. 5 10.NETWORKDAYS . 5 11.NOW. 6 12.SECOND. 6 13.TIME. 6 14.TIMEVALUE . 6 15.TODAY. 6 16.WEEKDAY. 6 17.WEEKNUM. 6 18.WORKDAY. 6 19.YEAR. 7 20.YEARFRAC . 7 (三)外部函數(shù). 7 1.EUROCONVERT . 7 2.SQL.REQUEST . 7 (四)工程函數(shù). 7 1.BESSELI. 7 2.BESSELJ. 8 3.BESSELK. 8 4.BESSELY. 8 5.BIN2DEC. 8 6.BIN2HEX. 8 7.BIN2OCT. 8 8.COMPLEX. 8 9.CONVERT. 8 10.DEC2BIN. 8 11.DEC2HEX. 8 12.DEC2OCT. 8 13.DELTA. 8 14.ERF. 8 15.ERFC. 9 16.GESTEP. 9 17.HEX2BIN. 9 18.HEX2DEC. 9 19.HEX2OCT. 9 20.IMABS. 9 21.IMAGINARY . 9 22.IMARGUMENT . 9 23.MCONJUGATE . 9 24.IMCOS. 9 25.IMDIV. 9 26.IMEXP. 9 27.IMLN. 9 28.IMLOG10. 10 29.IMLOG2. 10 30.IMPOWER. 10 31.IMPRODUCT . 10 32.IMREAL. 10 33.IMSIN. 10 34.IMSQRT. 10 35.IMSUB. 10 36.IMSUM. 10 37.OCT2BIN. 10 38.OCT2DEC. 10 39.OCT2HEX. 10 (五)財務(wù)函數(shù). 10 1.ACCRINT. 10 2.ACCRINTM. 113.AMORDEGRC . 114.AMORLINC. 115.COUPDAYBS . 116.COUPDAYS. 117.COUPDAYSNC . 118.COUPNUM. 119.COUPPCD. 1110.CUMIPMT. 1111.CUMPRINC . 12 12.DB. 12 13.DDB. 12 14.DISC. 12 15.DOLLARDE . 12 16.DOLLARFR . 12 17.DURATION . 12 18.EFFECT. 12 19.FV. 12 20.FVSCHEDULE . 12 21.INTRATE. 13 22.IPMT.