Excel2003常用函数完全手册 目 录 一、函数应用基础........... 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.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 (三)外部函数....................... 7 1.EUROCONVERT ................ 7 2.SQL.REQUEST ......…..................... 7 (四)工程函数....................... 7 1.BESSELI.........…….............. 7 2.BESSELJ..........……......