目录一、函数应用基础..........................1（一）函数和公式1.什么是函数2.什么是公式（二）函数的参数1.常量2.逻辑值3.数组4.错误值5.单元格引用6.嵌套函数7.名称和标志（三）函数输入方法1.“插入函数”对话框2.编辑栏输入二、函数速查一览(一)数据库函数.1.DAVERAGE.2.DCOUNT3.DCOUNTA4.DGET..............................35.DMAX..............................36.DMIN..............................37.DPRODUCYT8.DSTDEV..........................39.DSTDEVP........................410.DSUM............................411.DVAR............................412.DVARP..........................413.GETPIVOTDATA............4(二)日期与时间函数...............41.DATE..............................42.DATEVALUE....................43.DAY................................44.DAYS360........................55.EDATE............................56.EOMONTH........................57.HOUR..............................58.MINUTE..........................59.MONTH............................510.NETWORKDAYS..............511.NOW..............................612.SECOND........................613.TIME............................614.TIMEVALUE..................615.TODAY..........................616.WEEKDAY......................617.WEEKNUM......................618.WORKDAY......................619.YEAR............................720.YEARFRAC....................7(三)外部函数...........................71.EUROCONVERT................72.SQL.REQUEST................7(四)工程函数...........................71.BESSELI........................72.BESSELJ........................83.BESSELK........................84.BESSELY........................85.BIN2DEC........................86.BIN2HEX........................87.BIN2OCT........................88.COMPLEX........................89.CONVERT........................810.DEC2BIN......................811.DEC2HEX......................812.DEC2OCT......................813.DELTA..........................814.ERF..............................815.ERFC............................916.GESTEP........................917.HEX2BIN......................918.HEX2DEC......................919.HEX2OCT......................920.IMAB