Excel函数应用手册.docx
- 文档编号:9377996
- 上传时间:2023-02-04
- 格式:DOCX
- 页数:129
- 大小:103.98KB
Excel函数应用手册.docx
《Excel函数应用手册.docx》由会员分享,可在线阅读,更多相关《Excel函数应用手册.docx(129页珍藏版)》请在冰豆网上搜索。
Excel函数应用手册
Excel函数用途、参数、用法速查表
(按Ctrl+F搜索)
一、数据库函数(13条)
DAVERAGE
DCOUNT
DCOUNTA
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DVAR
DVARP
GETPIVOTDATA
二、日期与时间函数(20条)
DATE
DATEVALUE
DAY
DAYS360
EDATE
EOMONTH
HOUR
MINUTE
MONTH
NETWORKDAYS
NOW
SECOND
TIME
TIMEVaLUE
TODAY
WEEKDAY
WEEKNUM
WORKDAY
YEAR
YEARFRAC
三、外部函数(2条)
EUROCONVERT
SQL.REQUEST
四、工程函数(39条)
BESSELI
BESSELJ
BESSELK
BESSELY
BIN2DEC
BIN2HEX
BIN2OCT
COMPLEX
CONVERT
DEC2BIN
DEC2HEX
DEC2OCT
DELTA
ERF
ERFC
GESTEP
HEX2BIN
HEX2DEC
HEX2OCT
IMABS
IMAGINARY
IMARGUMENT
MCONJUGATE
IMCOS
IMDIV
IMEXP
IMLN
IMLOG10
IMLOG2
IMPOWER
IMPRODUCT
IMREAL
IMSIN
IMSQRT
IMSUB
IMSUM
OCT2BIN
OCT2DEC
OCT2HEX
五、财务函数(52条)
ACCRINT
ACCRINTM
AMORDEGRC
AMORLINC
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNUM
COUPPCD
CUMIPMT
CUMPRINC
DB
DDB
DISC
DOLLARDE
DOLLARFR
DURATION
EFFECT
FV
FVSCHEDULE
INTRATE
IPMT
IRR
ISPMT
MDURATION
MIRR
NOMINAL
NPER
NPV
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
PMT
PPMT
PRICE
PRICEDISC
PRICEMAT
PV
RATE
RECEIVED
SLN
SYD
TBILLEQ
TBILLPRICE
TBILLYIELD
VDB
XIRR
XNPV
YIELD
YIELDDISC
YIELDMAT
六、信息函数(9条)
CELL
ERROR.TYPE
INFO
IS类
ISEVEN
ISODD
N
NA
TYPE
ISERROR
七、逻辑运算符(6条)
AND
FALSE
IF
NOT
OR
TRUE
八、查找和引用函数(17条)
ADDRESS
AREAS
CHOOSE
COLUMN
COLUMNS
HLOOKUP
HYPERLINK
INDEX
INDIRECT
LOOKUP
MATCH
OFFSET
ROW
ROWS
RTD
TRANSPOSE
VLOOKUP
九、数学和三角函数(60条)
ABS
ACOS
ACOSH
ASIN
ASINH
ATAN
ATAN2
ATANH
CEILING
COMBIN
COS
COSH
COUNTIF
DEGREES
EVEN
EXP
FACT
FACTDOUBLE
FLOOR
GCD
INT
LCM
LN
LOG
LOG10
MDETERM
MINVERSE
MMULT
MOD
MROUND
MULTINOMIAL
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RANDBETWEEN
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SERIESSUM
SIGN
SIN
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
TAN
TANH
TRUNC
十、统计函数(80条)
AVEDEV
AVERAGE
AVERAGEA
BETADIST
BETAINV
BINOMDIST
CHIDIST
CHIINV
CHITEST
CONFIDENCE
CORREL
COUNT
COUNTA
COUNTBLANK
COUNTIF
COVAR
CRITBINOM
DEVSQ
EXPONDIST
FDIST
FINV
FISHER
FISHERINV
FORECAST
FREQUENCY
FTEST
GAMMADIST
GAMMAINV
GAMMALN
GEOMEAN
GROWTH
HARMEAN
HYPGEOMDIST
INTERCEPT
KURT
LARGE
LINEST
LOGEST
LOGINV
LOGNORMDIST
MAX
MAXA
MEDIAN
MIN
MINA
MODE
NEGBINOMDIST
NORMDIST
NORMSINV
NORMSDIST
NORMSINV
PEARSON
PERCENTILE
PERCENTRANK
PERMUT
POISSON
PROB
QUARTILE
RANK
RSQ
SKEW
SLOPEa
SMALL
STANDARDIZE
STDEV
STDEVA
STDEVP
STDEVPA
STEYX
TDIST
TINV
TREND
TRIMMEAN
TTEST
VAR
VARA
VARP
VARPA
WEIBULL
ZTEST
十一、文本和数据函数(28条)
ASC
CHAR
CLEAN
CODE
CONCATENATE
DOLLAR或RMB
EXACT
FIND
FINDB
FIXED
JIS
LEFT或LEFTB
LEN或LENB
LOWER
MID或MIDB
PHONETIC
PROPER
REPLACE或REPL
REPT
RIGHT或RIGHTB
SEARCH或SEARC
SUBSTITUTE
T
TEXT
TRIM
UPPER
VALUE
WIDECHAR
用来检验数值或引用类型的函数--IS类函数
IS类函数是指用来检验数值或引用类型的工作表函数,在Excel中一共有九个此类函数。
(1)ISBLANK如果值为空,则返回TRUE
(2)ISERR如果值为除#N/A以外的任何错误值,则返回TRUE
(3)ISERROR如果值为任何错误值,则返回TRUE
(4)ISLOGICAL如果值为逻辑值,则返回TRUE
(5)ISNA如果值为#N/A错误值,则返回TRUE
(6)ISNONTEXT如果值不是文本,则返回TRUE
(7)ISNUMBER如果值为数字,则返回TRUE
(8)ISREF如果值为引用,则返回TRUE
(9)ISTEXT如果值为文本,则返回TRUE
Excel2003
函数应用完全手册
张迎新著
二〇〇四年二月二日
目录
一、函数应用基础..........................................................................................................................................................9
(一)函数和公式...................................................................................................................................................9
1.什么是函数...................................................................................................................................................9
2.什么是公式...................................................................................................................................................9
(二)函数的参数..................................................................................................................................................9
1.常量................................................................................................................................................................10
2.逻辑值...........................................................................................................................................................10
3.数组.................................................................................................................................................................10
4.错误值............................................................................................................................................................10
5.单元格引用..................................................................................................................................................10
6.嵌套函数......................................................................................................................................................
7.名称和标志..................................................................................................................................................
(三)函数输入方法..............................................................................................................................................
1.“插入函数”对话框..................................................................................................................................
2.编辑栏输入..................................................................................................................................................
二、函数速查一览..........................................................................................................................................................13
(一)数据库函数.......................................................................................................................................................13
1.DAVERAGE....................................................................................................................................................13
2.DCOUNT.........................................................................................................................................................13
3.DCOUNTA......................................................................................................................................................13
4.DGET..............................................................................................................................................................
5.DMAX..............................................................................................................................................................
6.DMIN..............................................................................................................................................................
7.DPRODUCT......................................................................................................................................................
8.DSTDEV..........................................................................................................................................................
9.DSTDEVP........................................................................................................................................................
10.DSUM............................................................................................................................................................
11.DVAR............................................................................................................................................................4
12.DVARP........................................................................................................................................................15
13.GETPIVOTDATA.......................................................................................................................................15
(二)日期与时间函数..............................................................................................................................................15
1.DATE...............................................................................................................................................................16
2.DATEVALUE................................................................................................................................................16
3.DAY...................................................................................................................................................................16
4.DAYS360.........................................................................................................................................................16
5.EDATE.............................................................................................................................................................16
6.EOMONTH........................................................................................................................................................
7.HOUR..............................................................................................................................................................
8.MINUTE..........................................................................................................................................................
9.MONTH.....................................................................................................................................................
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Excel 函数 应用 手册