函数速查表

小编still说： 　　Excel很强！如果你学会使用Excel函数，你会发现Excel真的很强！我们做这个选题，希望能帮助您学好Excel函数，用好Excel。现在已经有一个专题《Excel函数入门与提高》，以后还会继续丰富这方面的内容的，敬请关注！

到我的主题社区跟我摆谈>> 到Office技巧主题社区和网友交流>> 到Excel函数主题社区和网友交流>>

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

七、逻辑运算符（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 ·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

到Office技巧主题社区和网友交流>>

到Excel函数主题社区和网友交流>>

  阅读关于 excel excel函数 excel函数教程 的全部文章