Excel2003函数应用完全手册目录一、函数应用基础.........................................................................................................................................1(一)函数和公式...............................................................................................................................................11.什么是函数..............................................................................................................................….................12.什么是公式..............................................................................................................................….................1(二)函数的参数................................................................................................................................................11.常量..........................................................................................................................................…..................12.逻辑值..........................................................................................................................................…..............13.数组............................................................................................................................................…................14.错误值........................................................................................................................................…................15.单元格引用...............................................................................................................................….................16.嵌套函数.................................................................................................................................…...................27.名称和标志........................................................................................................................…........................2(三)函数输入方法.............................................................................................................................................21.“插入函数”对话框...............................................................................................................................…..22.编辑栏输入...............................................................................................................................................…..3二、函数速查一览............................................................................................................................................3(一)数据库函数...............................................................................................................................................31.DAVERAGE.(返回数据库或数据清单中满足指定条件的列中数值的平)................................32.DCOUNT.....(返回数据库或数据清单的指定字段)........................................................................…….......33.DCOUNTA.(返回数据库或数据清单指定字段中满足给定条件的非空单元格数目)...............................34.DGET..(从数据清单或数据库中提取符合指定条件的单个值。)……………………………..……..…...35.DMAX.(返回数据清单或数据库的指定列中，满足给定条件单元格中的最大数值)..............................36.DMIN...(返回数据清单或数据库的指定列中满足给定条件的单元格中的最小数字)…...
