Excel2003函数应用完全手册.pdf

1 Excel 2003 Excel 2003 函数应用完全手册 张迎新 著 二〇〇四年二月二日 二〇〇四年二月二日 2 目 录 目 录 一、函数应用基础..........................................................................................................................................................1 （一）函数和公式..................................................................................................................................................1 1.什么是函数..................................................................................................................................................1 2.什么是公式..................................................................................................................................................1 （二）函数的参数..................................................................................................................................................1 1.常量..............................................................................................................................................................1 2.逻辑值..........................................................................................................................................................1 3.数组..............................................................................................................................................................1 4.错误值..........................................................................................................................................................1 5.单元格引用..................................................................................................................................................1 6.嵌套函数......................................................................................................................................................2 7.名称和标志..................................................................................................................................................2 （三）函数输入方法..............................................................................................................................................2 1.“插入函数”对话框..................................................................................................................................2 2.编辑栏输入..................................................................................................................................................3 二、函数速查一览..........................................................................................................................................................3 一数据库函数.......................................................................................................................................................3 1.DAVERAGE......................................................................................................................................................3 2.DCOUNT..........................................................................................................................................................3 3.DCOUNTA........................................................................................................................................................3 4.DGET..............................................................................................................................................................3 5.DMAX..............................................................................................................................................................3 6.DMIN..............................................................................................................................................................3 7.DPRODUCT......................................................................................................................................................3 8.DSTDEV..........................................................................................................................................................3 9.DSTDEVP........................................................................................................................................................4 10.DSUM............................................................................................................................................................4 11.DVAR............................................................................................................................................................4 12.DVARP..........................................................................................................................................................4 13.GETPIVOTDATA............................................................................................................................................4 二日期与时间函数...............................................................................................................................................4 1.DATE..............................................................................................................................................................4 2.DATUE....................................................................................................................................................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 3 11.NOW..............................................................................................................................................................6 12.SECOND........................................................................................................................................................6 13.TIME............................................................................................................................................................6 14.TIMUE..................................................................................................................................................6 15.TODAY..........................................................................................................................................................6 16.WEEKDAY......................................................................................................................................................6 17.WEEKNUM......................................................................................................................................................6 18.WORKDAY......................................................................................................................................................6 19.YEAR............................................................................................................................................................7 20.YEARFRAC....................................................................................................................................................7 三外部函数...........................................................................................................................................................7 1.EUROCONVERT................................................................................................................................................7 2.SQL.REQUEST................................................................................................................................................7 四工程函数...........................................................................................................................................................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 4 33.IMSIN........................................................................................................................................................10 34.IMSQRT......................................................................................................................................................10 35.IMSUB........................................................................................................................................................10 36.IMSUM........................................................................................................................................................10 37.OCT2BIN.................................................................................................................................................