Excel函数手册[资料].doc

目录 TOC \o 1-3 \h \z \u HYPERLINK \l _Toc154798436 一、函数应用基础 PAGEREF _Toc154798436 \h 1 HYPERLINK \l _Toc154798437 (一)函数和公式 PAGEREF _Toc154798437 \h 1 HYPERLINK \l _Toc154798438 1.什么是函数 PAGEREF _Toc154798438 \h 1 HYPERLINK \l _Toc154798439 2.什么是公式 PAGEREF _Toc154798439 \h 1 HYPERLINK \l _Toc154798440 （二）函数的参数 PAGEREF _Toc154798440 \h 1 HYPERLINK \l _Toc154798441 1.常量 PAGEREF _Toc154798441 \h 1 HYPERLINK \l _Toc154798442 2.逻辑值 PAGEREF _Toc154798442 \h 2 HYPERLINK \l _Toc154798443 3.数组 PAGEREF _Toc154798443 \h 2 HYPERLINK \l _Toc154798444 4.错误值 PAGEREF _Toc154798444 \h 2 HYPERLINK \l _Toc154798445 5.单元格引用 PAGEREF _Toc154798445 \h 2 HYPERLINK \l _Toc154798446 6.嵌套函数 PAGEREF _Toc154798446 \h 3 HYPERLINK \l _Toc154798447 7.名称和标志 PAGEREF _Toc154798447 \h 3 HYPERLINK \l _Toc154798448 （三）函数输入方法 PAGEREF _Toc154798448 \h 4 HYPERLINK \l _Toc154798449 1.“插入函数”对话框 PAGEREF _Toc154798449 \h 4 HYPERLINK \l _Toc154798450 2.编辑栏输入 PAGEREF _Toc154798450 \h 4 HYPERLINK \l _Toc154798451 二、函数速查一览 PAGEREF _Toc154798451 \h 5 HYPERLINK \l _Toc154798452 (一)数据库函数 PAGEREF _Toc154798452 \h 5 HYPERLINK \l _Toc154798453 1.DAVERAGE PAGEREF _Toc154798453 \h 5 HYPERLINK \l _Toc154798454 2.DCOUNT PAGEREF _Toc154798454 \h 5 HYPERLINK \l _Toc154798455 3.DCOUNTA PAGEREF _Toc154798455 \h 5 HYPERLINK \l _Toc154798456 4.DGET PAGEREF _Toc154798456 \h 5 HYPERLINK \l _Toc154798457 5.DMAX PAGEREF _Toc154798457 \h 5 HYPERLINK \l _Toc154798458 6.DMIN PAGEREF _Toc154798458 \h 6 HYPERLINK \l _Toc154798459 7.DPRODUCT PAGEREF _Toc154798459 \h 6 HYPERLINK \l _Toc154798460 8.DSTDEV PAGEREF _Toc154798460 \h 6 HYPERLINK \l _Toc154798461 9.DSTDEVP PAGEREF _Toc154798461 \h 6 HYPERLINK \l _Toc154798462 10.DSUM PAGEREF _Toc154798462 \h 6 HYPERLINK \l _Toc154798463 11.DVAR PAGEREF _Toc154798463 \h 6 HYPERLINK \l _Toc154798464 12.DVARP PAGEREF _Toc154798464 \h 7 HYPERLINK \l _Toc154798465 13.GETPIVOTDATA PAGEREF _Toc154798465 \h 7 HYPERL