文件名称：MS Excel 函数手册
文件大小：1.99MB
文件格式：PDF
更新时间：2021-12-13 14:59:00
excel
目录 一. 函数应用基础 ................................................................................................................ 1 1. 函数和公式 ................................................................................................................ 1 [1]. 什么是函数 ..................................................................................................... 1 [2]. 什么是公式 ..................................................................................................... 1 2. 函数参数 .................................................................................................................... 1 [1]. 常量 ................................................................................................................ 1 [2]. 逻辑值 ............................................................................................................ 2 [3]. 数组 ................................................................................................................ 2 [4]. 错误值 ............................................................................................................ 2 [5]. 单元格引用 ..................................................................................................... 2 [6]. 嵌套函数 ......................................................................................................... 3 [7]. 名称和标志 ..................................................................................................... 3 3. 函数输入方法 ............................................................................................................ 3 [1]. “插入函数”对话框 ....................................................................................... 3 [2]. 编辑栏输入 ..................................................................................................... 4 二. 函数速查一览 ................................................................................................................ 4 1. 数据库函数 ................................................................................................................ 4 [1]. DAVERAGE ................................................................................................... 4 [2]. DCOUNT ........................................................................................................ 4 [3]. DCOUNTA ..................................................................................................... 5 [4]. DGET .............................................................................................................. 5 [5]. DMAX ............................................................................................................ 5 [6]. DMIN .............................................................................................................. 5 [7]. DPRODUCT .................................................................................................... 5 [8]. DSTDEV .......................................................................................................... 5 [9]. DSTDEVP) ....................................................................................................... 5 [10]. DSUM ...................................................................................................... 6 [11]. DVAR ...................................................................................................... 6 [12]. DVARP .................................................................................................... 6 [13]. GETPIVOTDATA...................................................................................... 6 2. 日期与时间函数 ......................................................................................................... 6 [1]. DATE............................................................................................................... 6 [2]. DATEVALUE ................................................................................................... 7 [3]. DAY ................................................................................................................ 7 [4]. DAYS360 ........................................................................................................ 7 [5]. EDATE ............................................................................................................. 8 [6]. EOMONTH ..................................................................................................... 8 [7]. HOUR ............................................................................................................. 8 [8]. MINUTE ........................................................................................................... 8 [9]. MONTH