MicrosoftOfficeExcel函数手册_excel官方文档

需积分: 50 398 浏览量更新于2023-05-26 评论 1 收藏 2MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

EXCEL 函数手册

SUNLION

Image Of Life

- i -

一. 函数应用基础 ................................................................................................................ 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 .......................................................................................................... 8

SUNLION

Image Of Life

- ii -

[10]. NETWORKDAYS...................................................................................... 9

[11]. NOW ....................................................................................................... 9

[12]. SECOND ................................................................................................. 9

[13]. TIME ........................................................................................................ 9

[14]. TIMEVALUE ........................................................................................... 10

[15]. TODAY .................................................................................................. 10

[16]. WEEKDAY ............................................................................................. 10

[17]. WEEKNUM ............................................................................................ 10

[18]. WORKDAY ............................................................................................ 10

[19]. YEAR ..................................................................................................... 11

[20]. YEARFRAC ........................................................................................... 11

3. 外部函数 .................................................................................................................. 11

[21]. EUROCONVERT ................................................................................... 11

[22]. SQL.REQUEST ....................................................................................... 12

4. 工程函数 .................................................................................................................. 12

[1]. BESSELI ......................................................................................................... 12

[2]. BESSELJ ........................................................................................................ 12

[3]. BESSELK ........................................................................................................ 12

[4]. BESSELY ........................................................................................................ 12

[5]. BIN2DEC ...................................................................................................... 12

[6]. BIN2HEX ....................................................................................................... 13

[7]. BIN2OCT ...................................................................................................... 13

[8]. COMPLEX .................................................................................................... 13

[9]. CONVERT .................................................................................................... 13

[10]. DEC2BIN ............................................................................................... 13

[11]. DEC2HEX .............................................................................................. 13

[12]. DEC2OCT ............................................................................................. 13

[13]. DELTA .................................................................................................... 14

[14]. ERF ........................................................................................................ 14

[15]. ERFC ..................................................................................................... 14

[16]. GESTEP .................................................................................................. 14

[17]. HEX2BIN ................................................................................................ 14

[18]. HEX2DEC .............................................................................................. 14

[19]. HEX2OCT .............................................................................................. 14

[20]. IMABS ................................................................................................... 15

[21]. IMAGINARY ......................................................................................... 15

[22]. IMARGUMENT ...................................................................................... 15

[23]. MCONJUGATE .................................................................................... 15

[24]. IMCOS .................................................................................................. 15

[25]. IMDIV .................................................................................................... 15

[26]. IMEXP .................................................................................................... 15

[27]. IMLN ...................................................................................................... 16

[28]. IMLOG10 .............................................................................................. 16

[29]. IMLOG2 ................................................................................................ 16

SUNLION

Image Of Life

- iii -

[30]. IMPOWER ............................................................................................. 16

[31]. IMPRODUCT ......................................................................................... 16

[32]. IMREAL ................................................................................................. 16

[33]. IMSIN ..................................................................................................... 16

[34]. IMSQRT ................................................................................................. 16

[35]. IMSUB .................................................................................................... 17

[36]. IMSUM .................................................................................................. 17

[37]. OCT2BIN ............................................................................................... 17

[38]. OCT2DEC ............................................................................................. 17

[39]. OCT2HEX .............................................................................................. 17

5. 财务函数 .................................................................................................................. 17

[1]. ACCRINT...................................................................................................... 17

[2]. ACCRINTM .................................................................................................. 18

[3]. AMORDEGRC ............................................................................................. 18

[4]. AMORLINC .................................................................................................. 18

[5]. COUPDAYBS ............................................................................................... 18

[6]. COUPDAYS ................................................................................................. 18

[7]. COUPDAYSNC ............................................................................................ 19

[8]. COUPNUM .................................................................................................. 19

[9]. COUPPCD ................................................................................................... 19

[10]. CUMIPMT .............................................................................................. 19

[11]. CUMPRINC ........................................................................................... 19

[12]. DB ......................................................................................................... 19

[13]. DDB ....................................................................................................... 20

[14]. DISC ...................................................................................................... 20

[15]. DOLLARDE ........................................................................................... 20

[16]. DOLLARFR ............................................................................................ 20

[17]. DURATION ............................................................................................ 20

[18]. EFFECT .................................................................................................. 20

[19]. FV .......................................................................................................... 21

[20]. FVSCHEDULE ........................................................................................ 21

[21]. INTRATE ................................................................................................. 21

[22]. IPMT ...................................................................................................... 21

[23]. IRR ......................................................................................................... 21

[24]. ISPMT .................................................................................................... 21

[25]. MDURATION ......................................................................................... 22

[26]. MIRR ...................................................................................................... 22

[27]. NOMINAL ............................................................................................. 22

[28]. NPER ..................................................................................................... 22

[29]. NPV ....................................................................................................... 22

[30]. ODDFPRICE .......................................................................................... 23

[31]. ODDFYIELD .......................................................................................... 23

[32]. ODDLPRICE .......................................................................................... 23

[33]. ODDLYIELD ........................................................................................... 23

SUNLION

Image Of Life

- iv -

[34]. PMT ....................................................................................................... 24

[35]. PPMT ..................................................................................................... 24

[36]. PRICE .................................................................................................... 24

[37]. PRICEDISC ............................................................................................ 24

[38]. PRICEMAT ............................................................................................ 24

[39]. PV ......................................................................................................... 25

[40]. RATE ...................................................................................................... 25

[41]. RECEIVED ............................................................................................. 25

[42]. SLN ........................................................................................................ 25

[43]. SYD ....................................................................................................... 25

[44]. TBILLEQ ................................................................................................. 25

[45]. TBILLPRICE ............................................................................................ 26

[46]. TBILLYIELD ............................................................................................. 26

[47]. VDB ....................................................................................................... 26

[48]. XIRR ....................................................................................................... 26

[49]. XNPV..................................................................................................... 26

[50]. YIELD ..................................................................................................... 26

[51]. YIELDDISC ............................................................................................ 27

[52]. YIELDMAT ............................................................................................. 27

6. 信息函数 .................................................................................................................. 27

[1]. CELL ............................................................................................................. 27

[2]. ERROR.TYPE ................................................................................................. 27

[3]. INFO ............................................................................................................. 28

[4]. IS 类函数 ....................................................................................................... 28

[5]. ISEVEN .......................................................................................................... 28

[6]. ISODD .......................................................................................................... 29

[7]. N ................................................................................................................... 29

[8]. NA ................................................................................................................ 29

[9]. TYPE .............................................................................................................. 29

7. 逻辑运算符 .............................................................................................................. 29

[1]. AND ............................................................................................................. 29

[2]. FALSE............................................................................................................ 30

[3]. IF ................................................................................................................... 30

[4]. NOT .............................................................................................................. 30

[5]. OR ................................................................................................................ 30

[6]. TRUE ............................................................................................................. 31

8. 查找和引用函数 ....................................................................................................... 31

[1]. ADDRESS...................................................................................................... 31

[2]. AREAS .......................................................................................................... 31

[3]. CHOOSE ...................................................................................................... 31

[4]. COLUMN ..................................................................................................... 32

[5]. COLUMNS ................................................................................................... 32

[6]. HLOOKUP .................................................................................................... 32

[7]. HYPERLINK ................................................................................................... 32

剩余91页未读，继续阅读

intel80586

粉丝: 77
资源: 178

会员权益专享

Microsoft Office Excel 函数手册

评论0

会员权益专享

最新资源

Microsoft Office Excel 函数手册

评论0

Excel教程 Excel函数教程

Excel函数教程 Excel函数教程

linux excel函数

to_excel函数原理

pandas toexcel函数

Excel函数大全—详细的excel函数库

excel函数公式大全2020

excel函数公式大全

python read_excel函数读取excel数据 绝对路径

Excel VBA帮助函数参考手册

将excel接口函数封装c++

opengl函数手册.chm中文

pandas如何实现excel函数

使用pandas库中的read_excel函数读取本地Excel文件时无法确定 Excel 文件格式,，必须手动指定引擎，该怎么解决

Excel函数高级篇+Excel操作使用技巧大全

excel lambda 函数用法

python中read_excel函数

excel函数index和match用法

excel函数 双条件行列交叉查询 xlookup

freertos api函数中文手册

会员权益专享

最新资源

python read_excel函数读取excel数据绝对路径

excel函数双条件行列交叉查询 xlookup