EXCEL-函数速查手册

《EXCEL-函数速查手册》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、EXCEL函数速查手册一、数学和三角函数（60条）・ABS・ACOS・ATAN2・ATANH・COUNTTF・DEGREES・FLOOR・GCD・LOG10・MDETERM・MULTINOMIAL・ODD・RADIANS・RAND・ROUXDUP•SERTESSUM•SQRTPI・SUBTOTAL・SUMX2MY2•SLMX2PY2二、统计函数（80条）・AVEDEV・AVERAGE・CHTDTST・CHTTNV・COUNTA•COUNTBLANK•EXPOND1ST・ED1ST•FREQUENCY・FTEST•GROWTH・HARMEAN・LINEST・

2、LOGEST・MEDIAN・MIN•NORMSINV・N0RMSD1ST•PERMUT・POISSON•SKEW・SLOPE・STDEVP・STDEVPA•TRIMMEAN・TTEST•WEIBULL・ZTEST三、文本和数据函数（28条）・ASC・CHAR・EXACT・FIND・LEN或LENB・LOWER・REPT・RIGHT或RIGHTB•TRIM・UPPER四、逻辑运算符（6条）・ACOSII•ASTN•CEILING・COMBIN•EVEN・EXP・1NT■LCM・MINVERSE・MMULT・Pl・POWER•RANDBETWEEN・ROMAN

3、・SIGN・STN・SUM・SUMIF・SUMXMY2・TAN・AVERAGEA・BETADIST•CHTTEST・CONFIDENCE•COUNTIF・COVAR・F1NV・FISHER・GAMMADTST・GAMMATNV•HYPGEOMDIST・INTERCEPT・LOGTNV・LOGNORMDTST•MINA・MODE・NORMSINV・PEARSON・PROB・QUARTILE・SMALL・STANDARDIZE・STEYX・TDIST・VAR・VARA・CLEAN・CODE・FIXDB・FIXED・MID或MIDB・PHONETIC・SEARC

4、H或SEARC•value・SUBSTITUTE・WTDECHAR・ASTMI・ATAN・COS・COSH・FACT・FACTDOUBLE・LN・LOG・MOD・MROUND・PRODUCT・QUOTIENT・ROUND・ROUNDDOWN・STNH・SQRT•SUMPRODUCT・SUMSQ・TANH・TRUNC・BETAINV・BINOMDIST•CORREL■COUNT•CRITBINOM・DEVSQ・F1SHERINV・FORECAST・GAMMALN・GEOMEAN・KURT・LARGE・MAX・MAXA・NEGBINOMDIST・NORMDIS

5、T・PERCENTILE・PERCENTRANK・RANK・RSQ・STDEV・STDEVA・TINV・TREND・VARP・VARPA・CONCATENATE・DOLLAR或RMB•Jis・LEFT或LEFTB•PROPER・REPLACE或REPL・T・TEXT•AND•FALSE・IF・NOT・OR・TRUE五、查找和引用函数（17条）・ADDRESS・AREAS・CHOOSE・COLUMN・COLUMNS・HLOOKUP•HYPERLINK•INDEX・INDIRECT・LOOKUP・MATCH・OFFSET・ROW・ROWS・RTD・TRANSP

6、OSE・VLOOKl'P六、数据库函数（13条）•DAVERAGE・DCOUNT・DCOUNTA・DGET•DMAX・DMTN・DPRODUCT・DSTDEV・DSTDEVP・DSUM・DVAR・DVARP・GETPTVOTDATA七、日期与时间函数（20条）・DATE・DATEVaLUE・DAY・DAYS360・EDATE・EOMONTH・HOUR・MINUTE・MONTH・NETWORKDAYS・NOW・SECOND・TIME・TIMEVaLUE・TODAY・WEEKDAY・WEEKNL'M・WORKDAY•YEAR•YEARFRAC八、外部函数（2条

7、）・EUROCONVERT・SQL.REQUEST九、工程函数（39条）・BESSELI・BESSELJ・BESSELK・BESSELY・BIN2DEC•BIN2HEX・BIN20CT・COMPLEX・CONVERT・DEC2BIN・DEC2HEX・DEC2OCT•DELTA・ERF・ERFC・GESTEP・HEX2BIN・HEX2DEC・HEX2OCT・1MABS・IMAGINARY・1MARGUMENT・MCONJUGATE・1MCOS・TMDTV•TMEXP・TMLN•TML0G10・TMI.0G2•TMPOWER•1MPR0DUCT•1MREAL・

8、1MS1N・1MSQRT・1MSUB・1MSUM・OCT2BIN・