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