目录EXCEL函数大全..........................................................................................................31.数据库和清单管理函数.........................................................................................32.日期和时间函数.....................................................................................................33.DDE和外部函数....................................................................................................44.工程函数.................................................................................................................5Excel2003常用函数......................................................................................................65.ABS函数................................................................................................................66.AND........................................................................................................................77.AVERAGE..............................................................................................................78.CELL.......................................................................................................................89.CHOOSE.................................................................................................................810.COLUMN函数...................................................................................................911.CONCATENATE函数........................................................................................912.COUNT.............................................................................................................1013.COUNTA...........................................................................................................1014.COUNTIF..........................................................................................................1015.DATEDIF函数..................................................................................................1116.DATE函数........................................................................................................1117.DAY函数..........................................................................................................1218.DCOUNT函数..................................................................................................1219.FIND..................................................................................................................1320.FREQUENCY函数..........................................................................................1321.IF........................................................................................................................1322.INDEX...............................................................................................................1423.INT.....................................................................................................................1524.ISERROR函数..................................................................................................1625.ISEVEN.............................................................................................................1626.ISODD...............................................................................................................1727.L...