Excel2003常用函数完全手册（完善版)资源-CSDN文库

4星 · 超过85%的资源需积分: 50 43 浏览量 2007-05-31 22:38:02 上传评论收藏 582KB DOC 举报

资源详情

资源评论

资源推荐

Excel 2003 
函数应用完全手册 
二〇〇四年二月二日
目 录 
一、函数应用基础......................................................................................................................................... 1 
(  一   )  函数和公式   ............................................................................................................................................... 1 
  什么是函数   ..............................................................................................................................…................. 1 
  什么是公式   ..............................................................................................................................…................. 1 
(  二   )  函数的参数   ................................................................................................................................................ 1 
  常量   ..........................................................................................................................................….................. 1 
  逻辑值   ..........................................................................................................................................….............. 1 
  数组   ............................................................................................................................................…................ 1 
  错误值   ........................................................................................................................................…................ 1 
  单元格引用   ...............................................................................................................................…................. 1 
  嵌套函数   .................................................................................................................................…................... 2 
  名称和标志   ........................................................................................................................…........................ 2 
(  三   )  函数输入方法   ............................................................................................................................................. 2 
  “ 插入函数”对话框   ...............................................................................................................................….. 2 
  编辑栏输入   ...............................................................................................................................................….. 3 
二、函数速查一览............................................................................................................................................ 3 
(  一   )  数据库函数   .....   ..  ...................................................................................................................................... 3 
DAVERAGE................................................................................................................................................... 3 
DCOUNT...........................................................................................................................................…......... 3
DCOUNTA.........................................................................................................................................…......... 3
DGET..........................................................................................................................................………......... 3
DMAX..........................................................................................................................................……........... 3
DMIN............................................................................................................................................………....... 3
DPRODUCT.................................................................................................................................................... 3
DSTDEV.........................................................................................................................................……......... 3
DSTDEVP........................................................................................................................................…............ 4
DSUM.............................................................................................................................................……........ 4
DVAR.............................................................................................................................................………..... 4
DVARP...........................................................................................................................................……......... 4
GETPIVOTDATA........................................................................................................................................... 4
(  二   )  日期与时间函数   ...   .................................................................................................................................... 4 
DATE...............................................................................................................................................…….......... 4 
DATEVALUE..................................................................................................................................….............. 4 
DAY.................................................................................................................................................……........... 4 
DAYS360.................................................................................................................................……................... 5 

EDATE.....................................................................................................................................…...................... 5 
EOMONTH............................................................................................................................…........................ 5 
HOUR........................................................................................................................................….................... 5 
MINUTE...................................................................................................................................…..................... 5 
MONTH........................................................................................................................................................... 5 
NETWORKDAYS ......................................................................................................................................... 5 
NOW........................................................................................................................................…................... 6 
SECOND................................................................................................................................….................... 6 
TIME.......................................................................................................................................…................... 6 
TIMEVALUE ................................................................................................................................................ 6 
TODAY....................................................................................................................................…................... 6 
WEEKDAY..................................................................................................................................................... 6 
WEEKNUM.................................................................................................................................................... 6 
WORKDAY..................................................................................................................................................... 6 
YEAR......................................................................................................................................….................... 7 
YEARFRAC ................................................................................................................................................... 7 
(  三   )  外部函数   ....   .............   .................................................................................................................................... 7 
EUROCONVERT .............................................................................................................................................. 7 
SQL.REQUEST ........................................................................................................................…..................... 7 
(  四   )  工程函数   ..................................................................................................................................................... 7 
BESSELI.......................................................................................................................................…….............. 7 
BESSELJ........................................................................................................................................……............. 8 
BESSELK.............................................................................................................................……....................... 8 
BESSELY......................................................................................................................................……............... 8 
BIN2DEC....................................................................................................................................……................. 8 
BIN2HEX..................................................................................................................................……................... 8 
BIN2OCT...................................................................................................................................……................... 8 
COMPLEX................................................................................................................................…....................... 8 
CONVERT.................................................................................................................................…….................... 8 
DEC2BIN................................................................................................................................…….................... 8 
DEC2HEX...............................................................................................................................…….................... 8 
DEC2OCT.................................................................................................................................…….................. 8 
DELTA......................................................................................................................................…….................. 8 
ERF...........................................................................................................................................…….................. 8 
ERFC........................................................................................................................................……................. 9 
GESTEP....................................................................................................................................…….................. 9 
HEX2BIN..................................................................................................................................……................. 9 
HEX2DEC..................................................................................................................................……................. 9 
HEX2OCT..................................................................................................................................……................. 9 
IMABS........................................................................................................................................……................ 9 
IMAGINARY ..............................................................................................................................…................... 9 
IMARGUMENT .....................................................................................................................…........................ 9 
MCONJUGATE .....................................................................................................................…........................ 9 
IMCOS.....................................................................................................................................……................... 9 
IMDIV....................................................................................................................................…….................... 9 

IMEXP...............................................................................................................................……......................... 9 
IMLN......................................................................................................................................…….................... 9 
IMLOG10............................................................................................................................……...................... 10 
IMLOG2..............................................................................................................................……...................... 10 
IMPOWER...............................................................................................................................…….................. 10 
IMPRODUCT .........................................................................................................................…...................... 10 
IMREAL......................................................................................................................................….............. 10 
IMSIN..........................................................................................................................................……........... 10 
IMSQRT......................................................................................................................................…............... 10 
IMSUB..........................................................................................................................................….…......... 10 
IMSUM..............................................................................................................................................…........ 10 
OCT2BIN...........................................................................................................................................…........ 10 
OCT2DEC........................................................................................................................................….......... 10 
OCT2HEX........................................................................................................................................….......... 10 
(  五   )  财务函数   ..  ...   ....   .......................................................................................................................................... 10 
ACCRINT.................................................................................................................................…................... 10 
ACCRINTM.......................................................................................................................….......................... 11
AMORDEGRC ..................................................................................................................….......................... 11
AMORLINC.......................................................................................................................….......................... 11
COUPDAYBS ................................................................................................................................................. 11
COUPDAYS........................................................................................................................…......................... 11
COUPDAYSNC ............................................................................................................................................... 11
COUPNUM.........................................................................................................................….......................... 11
COUPPCD.........................................................................................................................…........................... 11
CUMIPMT......................................................................................................................…............................ 11
CUMPRINC ...................................................................................................................…............................ 12 
DB...................................................................................................................................……........................ 12 
DDB....................................................................................................................................……..................... 12 
DISC..........................................................................................................................................…….............. 12 
DOLLARDE ............................................................................................................................…................... 12 
DOLLARFR ............................................................................................................................…................... 12 
DURATION .............................................................................................................................…................... 12 
EFFECT....................................................................................................................................……............... 12 
FV..................................................................................................................................................…….......... 12 
FVSCHEDULE ..........................................................................................................................…................. 12 
INTRATE..................................................................................................................................……............... 13 
IPMT.........................................................................................................................................……............... 13 
IRR............................................................................................................................................……............... 13 
ISPMT......................................................................................................................................……................ 13 
MDURATION ........................................................................................................................…..................... 13 
MIRR.......................................................................................................................................……................. 13 
NOMINAL..............................................................................................................................…..................... 13 
NPER.......................................................................................................................................……................. 13 
NPV.............................................................................................................................................…….............. 13 
ODDFPRICE ..............................................................................................................................…................. 13 
ODDFYIELD .....................................................................................................…......................................... 14 

ODDLPRICE .....................................................................................................…......................................... 14 
ODDLYIELD ......................................................................................................…........................................ 14 
PMT.......................................................................................................................…….................................. 14 
PPMT......................................................................................................................……................................. 14 
PRICE......................................................................................................................……................................ 14 
PRICEDISC ............................................................................................................…................................... 14 
PRICEMAT ...............................................................................................................…................................. 15 
PV................................................................................................................................……............................ 15 
RATE............................................................................................................................…............................ 15 
RECEIVED ................................................................................................................................................. 15 
SLN................................................................................................................................….......................... 15 
SYD.................................................................................................................................…......................... 15 
TBILLEQ..........................................................................................................................…........................ 15 
TBILLPRICE .....................................................................................................................…....................... 15 
TBILLYIELD ..................................................................................................................….......................... 15 
VDB.................................................................................................................................….......................... 15 
XIRR...............................................................................................................................….......................... 16 
XNPV..............................................................................................................................…........................... 16 
YIELD.............................................................................................................................….......................... 16 
YIELDDISC ...................................................................................................................….......................... 16 
YIELDMAT ................................................................................................................................................. 16 
(  六   )  信息函数   ......   .  ........................................................................................................................................... 16 
CELL...........................................................................................................................…................................ 16 
ERROR.TYPE ..................................................................................................................…........................... 16 
INFO.................................................................................................................................……........................ 16 
IS    类函数   ..........................................................................................................................……....................... 17 
ISEVEN..............................................................................................................................……....................... 17 
ISODD....................................................................................................................................……..................... 17 
N................................................................................................................................................................. 17 
NA............................................................................................................................................................... 17 
TYPE........................................................................................................................................................... 18 
(  七   )  逻辑运算符   .......   ......................................................................................................................................... 18 
AND............................................................................................................................................................. 18 
FALSE......................................................................................................................................................... 18 
IF............................................................................................................................................................... 18 
NOT............................................................................................................................................................. 18 
OR............................................................................................................................................................... 18 
TRUE........................................................................................................................................................... 18 
(  八   )  查找和引用函数   ....   .................................................................................................................................... 19 
ADDRESS..................................................................................................................................................... 19 
AREAS......................................................................................................................................................... 19 
CHOOSE....................................................................................................................................................... 19 
COLUMN....................................................................................................................................................... 19 
COLUMNS..................................................................................................................................................... 19 

HLOOKUP..................................................................................................................................................... 19 
HYPERLINK ................................................................................................................................................. 19 
INDEX......................................................................................................................................................... 20 
INDIRECT................................................................................................................................................... 20 
LOOKUP..................................................................................................................................................... 20 
MATCH....................................................................................................................................................... 20 
OFFSET..................................................................................................................................................... 21 
ROW........................................................................................................................................................... 21 
ROWS......................................................................................................................................................... 21 
RTD........................................................................................................................................................... 21 
TRANSPOSE ............................................................................................................................................... 21 
VLOOKUP................................................................................................................................................... 21 
(  九   )  数学和三角函数   ....   ..  ...................................................................................................................................... 21 
ABS............................................................................................................................................................. 21 
ACOS........................................................................................................................................................... 21 
ACOSH......................................................................................................................................................... 22 
ASIN........................................................................................................................................................... 22 
ASINH......................................................................................................................................................... 22 
ATAN........................................................................................................................................................... 22 
ATAN2......................................................................................................................................................... 22 
ATANH......................................................................................................................................................... 22 
CEILING..................................................................................................................................................... 22 
COMBIN..................................................................................................................................................... 22 
COS........................................................................................................................................................... 22 
COSH......................................................................................................................................................... 23 
COUNTIF................................................................................................................................................... 23 
DEGREES................................................................................................................................................... 23 
EVEN......................................................................................................................................................... 23 
EXP........................................................................................................................................................... 23 
FACT......................................................................................................................................................... 23 
FACTDOUBLE ............................................................................................................................................. 23 
FLOOR....................................................................................................................................................... 23 
GCD........................................................................................................................................................... 23 
INT........................................................................................................................................................... 23 
LCM........................................................................................................................................................... 24 
LN............................................................................................................................................................. 24 
LOG........................................................................................................................................................... 24 
LOG10....................................................................................................................................................... 24 
MDETERM................................................................................................................................................... 24 
MINVERSE ................................................................................................................................................. 24 
MMULT....................................................................................................................................................... 24 
MOD........................................................................................................................................................... 24 
MROUND..................................................................................................................................................... 24 
MULTINOMIAL ........................................................................................................................................... 25 
ODD........................................................................................................................................................... 25 
PI............................................................................................................................................................. 25 