EXCEL函数手册.doc

EXCEL函数手册 SUNLION - 2009 目录 函数应用基础 i 1. 函数和公式 i [1] .什么是函数 i [2] .什么是公式 1 2. 函数#数 1 [1] .常量 1 [2] .逻辑值 2 [3] .数组 2 [4] .错误值 2 [5] .单元格引用 2 [6] .嵌套函数 3 [7] .名称和标志 3 3. 函数输入方法 3 [1] . “插入函数，，对话框 3 [2] .编辑栏输入 4 二. 函数速查一览 4 1. 数据库函数 4 [1] . DAVERAGE 4 [2] . DCOUNT 4 [3] . DCOUNTA 5 [4] . DGET 5 [5] . DMAX 5 [6] . DMIN 5 [7] . DPRODUCT 5 [8] . DSTDEV 5 [9] . DSTDEVP) 5 [10] . DSUM 6 [11] . DVAR 6 [12] . DVARP 6 [13] . GETPIVOTDATA 6 2. 日期与时间函数 6 [1] . DATE 6 [2] . DATEVALUE 7 [3] . DAY 7 [4] . DAYS360 7 [5] . EDATE 8 [6] . EOMONTH 8 [7] . HOUR 8 [8] . MINUTE 8 [9] . MONTH 8 [10] . NETWORKDAYS 9 [11] . NOW 9 [12] . SECOND 9 [13] . TIME 9 [14] . TIMEVALUE 10 [15] . TODAY 10 [16] . WEEKDAY 10 [17] . WEEKNUM 10 [18] . WORKDAY 10 [19] . YEAR 11 [20] . YEARFRAC 11 3. 外部函数 11 [21] . EUROCONVERT 11 [22] . SQL.REQUEST 12 4. 工程函数 12 [1] . BESSELI 12 [2] . BESSELJ 12 [3] . BESSELK 12 [4] . BESSELY 12 [5] . BIN2DEC 12 [6] . BIN2HEX 13 [7] . BIN2OCT 13 [8] . COMPLEX 13 [9] . CONVERT 13 [10] . DEC2BIN 13 [11] . DEC2HEX 13 [12] . DEC2OCT 13 [13] . DELTA 14 [14] . ERF 14 [15] . ERFC 14 [16] . GESTEP 14 [17] . HEX2BIN 14 [18] . HEX2DEC 14 [19] . HEX2OCT 14 [20] . IMABS 15 [21] . IMAGINARY 15 [22] . IMARGUMENT 15 [23] . MCONJUGATE 15 [24] . IMCOS 15 [25] . IMDIV 15 [26] . IMEXP 15 [27] . IMLN 16 [28] . IMLOG10 16 [29] . IMLOG2 16[30] . IMPOWER 16 [31] . IMPRODUCT 16 [32] . IMREAL 16 [33] . IMSIN 16 [34] . IMSQRT 16 [35] . IMSUB 17 [36] . IMSUM 17 [37] . OCT2BIN 17 [38] . OCT2DEC 17 [39] . OCT2HEX 17 5. 财务函数 17 [1] . ACCRINT 17 [2] . ACCRINTM 18 [3] . AMORDEGRC 18 [4] . AMORLINC 18 [5] . COUPDAYBS 18 [6] . COUPDAYS 18 [7] . COUPDAYSNC 19 [8] . COUPNUM 19 [9] . COUPPCD 19 [10] . CUMIPMT 19 [11] . CUMPRINC 19 [12] . DB 19 [13] . DDB 20 [14] . DISC 20 [15] . DOLLARDE 20 [16] . DOLLARFR 20 [17] . DURATION 20 [18] . EFFECT 20 [19] . FV 21 [20] . FVSCHEDULE 21 [21] . INTRATE 21 [22] . IPMT 21 [23] . IRR 21 [24] . ISPMT 21 [25] . MDURATION 22 [26] . MIRR 22 [27] . NOMINAL 22 [28] . NPER 22 [2