45fan.com - 路饭网

搜索: 您的位置主页 > 网络频道 > 阅读资讯:Excel函数速查表的内容介绍

Excel函数速查表的内容介绍

2016-07-14 06:59:23 来源:www.45fan.com 【

Excel函数速查表的内容介绍

http://tech.ddvip.com
 
一、数据库函数
 
·DAVERAGE ·DCOUNT ·DCOUNTA ·DGET ·DMAX ·DMIN
 
·DPRODUCT ·DSTDEV ·DSTDEVP ·DSUM ·DVAR ·DVARP
 
·GETPIVOTDATA
 
二、日期与时间函数
 
·DATE ·DATEVaLUE ·DAY ·DAYS360 ·EDATE ·EOMONTH
 
·HOUR ·MINUTE ·MONTH ·NETWORKDAYS ·NOW ·SECOND
 
·TIME ·TIMEVaLUE ·TODAY ·WEEKDAY ·WEEKNUM ·WORKDAY
 
·YEAR ·YEARFRAC
 
三、外部函数
 
·EUROCONVERT ·SQL.REQUEST
 
四、工程函数
 
·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
 
五、财务函数
 
·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
 
六、信息函数
 
·CELL ·ERROR.TYPE ·INFO ·IS类 ·ISEVEN ·ISODD
 
·N ·NA ·TYPE
 
七、逻辑运算符
 
·AND ·FALSE ·IF ·NOT ·OR ·TRUE
 
八、查找和引用函数
 
·ADDRESS ·AREAS ·CHOOSE ·COLUMN ·COLUMNS ·HLOOKUP
 
·HYPERLINK ·INDEX ·INDIRECT ·LOOKUP ·MATCH ·OFFSET
 
·ROW ·ROWS ·RTD ·TRANSPOSE ·VLOOKUP
 
九、数学和三角函数
 
·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
 
十、统计函数
 
·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
 
十一、文本和数据函数
 
·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
 

本文地址:http://www.45fan.com/a/question/57275.html
Tags: 函数 excel 查表
编辑:路饭网
关于我们 | 联系我们 | 友情链接 | 网站地图 | Sitemap | App | 返回顶部