Excel 2003
函数应用完全手册
目录
Excel 2003.....................................................................................................................1
目录 ...............................................................................................................................1
一、函数应用基础............................................................................................... 11
（一）函数和公式......................................................................................... 11
1.什么是函数............................................................................................ 11
2.什么是公式............................................................................................ 11
（二）函数的参数......................................................................................... 11
1.常量........................................................................................................12
2.逻辑值....................................................................................................12
3.数组........................................................................................................12
4.错误值....................................................................................................12
5.单元格引用............................................................................................12
6.嵌套函数................................................................................................13
7.名称和标志............................................................................................13
（三）函数输入方法.....................................................................................14
1.“插入函数”对话框............................................................................14
2.编辑栏输入............................................................................................14
二、函数速查一览...............................................................................................15
(一)数据库函数 ..............................................................................................15
1.DAVERAGE..........................................................................................15
2.DCOUNT ...............................................................................................15
3.DCOUNTA ............................................................................................15
4.DGET .....................................................................................................15
5.DMAX....................................................................................................16
6.DMIN .....................................................................................................16
7.DPRODUCT ..........................................................................................16
8.DSTDEV ................................................................................................16
9.DSTDEVP..............................................................................................16
1
10.DSUM ..................................................................................................16
11.DVAR...................................................................................................16
12.DVARP ................................................................................................17
13.GETPIVOTDATA ...............................................................................17
(二)日期与时间函数 ......................................................................................17
1.DATE .....................................................................................................17
2.DATEVALUE........................................................................................17
3.DAY .......................................................................................................18
4.DAYS360 ...............................................................................................18
5.EDATE...................................................................................................18
6.EOMONTH............................................................................................19
7.HOUR.....................................................................................................19
8.MINUTE ................................................................................................19
9.MONTH .................................................................................................19
10.NETWORKDAYS...............................................................................20
11.NOW.....................................................................................................20
12.SECOND..............................................................................................20
13.TIME ....................................................................................................20
14.TIMEVALUE.......................................................................................21
15.TODAY................................................................................................21
16.WEEKDAY..........................................................................................21
17.WEEKNUM.........................................................................................21
18.WORKDAY.........................................................................................21
19.YEAR ...................................................................................................22
20.YEARFRAC.........................................................................................22
(三)外部函数 ..................................................................................................22
1.EUROCONVERT ..................................................................................22
2.SQL.REQUEST .....................................................................................23
(四)工程函数 ..................................................................................................23
1.BESSELI ................................................................................................23
2.BESSELJ................................................................................................24
3.BESSELK...............................................................................................24
4.BESSELY...............................................................................................24
5.BIN2DEC...............................................................................................24
6.BIN2HEX...............................................................................................24
7.BIN2OCT...............................................................................................24
8.COMPLEX.............................................................................................24
9.CONVERT.............................................................................................25
10.DEC2BIN.............................................................................................25
11.DEC2HEX............................................................................................25
12.DEC2OCT............................................................................................25
13.DELTA.................................................................................................25
2
14.ERF.......................................................................................................25
15.ERFC....................................................................................................25
16.GESTEP ...............................................................................................26
17.HEX2BIN.............................................................................................26
18.HEX2DEC............................................................................................26
19.HEX2OCT............................................................................................26
20.IMABS .................................................................................................26
21.IMAGINARY.......................................................................................26
22.IMARGUMENT ..................................................................................26
23.MCONJUGATE...................................................................................26
24.IMCOS .................................................................................................27
25.IMDIV..................................................................................................27
26.IMEXP..................................................................................................27
27.IMLN....................................................................................................27
28.IMLOG10.............................................................................................27
29.IMLOG2...............................................................................................27
30.IMPOWER...........................................................................................27
31.IMPRODUCT ......................................................................................27
32.IMREAL...............................................................................................28
33.IMSIN...................................................................................................28
34.IMSQRT...............................................................................................28
35.IMSUB .................................................................................................28
36.IMSUM ................................................................................................28
37.OCT2BIN.............................................................................................28
38.OCT2DEC............................................................................................28
39.OCT2HEX............................................................................................28
(五)财务函数 ..................................................................................................29
1.ACCRINT ..............................................................................................29
2.ACCRINTM...........................................................................................29
3.AMORDEGRC ......................................................................................29
4.AMORLINC...........................................................................................29
5.COUPDAYBS........................................................................................30
6.COUPDAYS ..........................................................................................30
7.COUPDAYSNC.....................................................................................30
8.COUPNUM............................................................................................30
9.COUPPCD..............................................................................................30
10.CUMIPMT ...........................................................................................30
11.CUMPRINC.........................................................................................31
12.DB.........................................................................................................31
13.DDB......................................................................................................31
14.DISC.....................................................................................................31
15.DOLLARDE ........................................................................................32
16.DOLLARFR.........................................................................................32
3
17.DURATION.........................................................................................32
18.EFFECT................................................................................................32
19.FV.........................................................................................................32
20.FVSCHEDULE....................................................................................32
21.INTRATE.............................................................................................33
22.IPMT ....................................................................................................33
23.IRR .......................................................................................................33
24.ISPMT ..................................................................................................33
25.MDURATION......................................................................................33
26.MIRR....................................................................................................33
27.NOMINAL...........................................................................................34
28.NPER....................................................................................................34
29.NPV......................................................................................................34
30.ODDFPRICE........................................................................................34
31.ODDFYIELD.......................................................................................34
32.ODDLPRICE........................................................................................35
33.ODDLYIELD.......................................................................................35
34.PMT......................................................................................................35
35.PPMT....................................................................................................35
36.PRICE...................................................................................................36
37.PRICEDISC..........................................................................................36
38.PRICEMAT..........................................................................................36
39.PV.........................................................................................................36
40.RATE....................................................................................................37
41.RECEIVED ..........................................................................................37
42.SLN.......................................................................................................37
43.SYD......................................................................................................37
44.TBILLEQ .............................................................................................37
45.TBILLPRICE .......................................................................................37
46.TBILLYIELD.......................................................................................38
47.VDB......................................................................................................38
48.XIRR ....................................................................................................38
49.XNPV ...................................................................................................38
50.YIELD..................................................................................................38
51.YIELDDISC.........................................................................................39
52.YIELDMAT.........................................................................................39
(六)信息函数 ..................................................................................................39
1.CELL......................................................................................................39
2.ERROR.TYPE........................................................................................39
3.INFO.......................................................................................................40
4.IS 类函数 ..............................................................................................40
5.ISEVEN..................................................................................................41
6.ISODD....................................................................................................41
4
7.N .............................................................................................................41
8.NA ..........................................................................................................41
9.TYPE......................................................................................................41
(七)逻辑运算符 ..............................................................................................42
1.AND .......................................................................................................42
2.FALSE....................................................................................................42
3.IF.............................................................................................................42
4.NOT........................................................................................................43
5.OR...........................................................................................................43
6.TRUE......................................................................................................43
(八)查找和引用函数 ......................................................................................44
1.ADDRESS..............................................................................................44
2.AREAS...................................................................................................44
3.CHOOSE................................................................................................44
4.COLUMN...............................................................................................44
5.COLUMNS ............................................................................................45
6.HLOOKUP.............................................................................................45
7.HYPERLINK .........................................................................................45
8.INDEX....................................................................................................45
9.INDIRECT .............................................................................................46
10.LOOKUP..............................................................................................46
11.MATCH................................................................................................47
12.OFFSET................................................................................................47
13.ROW.....................................................................................................48
14.ROWS ..................................................................................................48
15.RTD......................................................................................................48
16.TRANSPOSE.......................................................................................48
17.VLOOKUP...........................................................................................48
(九)数学和三角函数 ......................................................................................49
1.ABS ........................................................................................................49
2.ACOS .....................................................................................................49
3.ACOSH ..................................................................................................49
4.ASIN.......................................................................................................49
5.ASINH....................................................................................................50
6.ATAN.....................................................................................................50
7.ATAN2...................................................................................................50
8.ATANH..................................................................................................50
9.CEILING................................................................................................50
10.COMBIN..............................................................................................51
11.COS ......................................................................................................51
12.COSH ...................................................................................................51
13.COUNTIF.............................................................................................51
5
评论0