Excel函数速查表1

来源:百度文库 编辑:神马文学网 时间:2024/03/28 20:36:33

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