首页 > 考试学习 > 电脑天地 > 电脑教程 > 办公文档 > excel和wps > 正文

Excel函数速查表
2010-11-01 10:24:35 来源：评论：0 点击：

一、数据库函数（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条）

四、工程函数（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

七、逻辑运算符（6条）

八、查找和引用函数（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	·SLOPE	·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

相关热词搜索：Excel 函数速查表

上一篇：第一页
下一篇：最后一页

分享到：

收藏

评论排行

依法纳税利国利民…请稍等...

适用2021年最新税收优惠政策

依法纳税利国利民…请稍等...

财税会计常用资料1

依法纳税利国利民…请稍等...

财税会计常用资料2

精彩内容06正在载入中…请稍等...

频道总排行

频道本月排行