文档介绍：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・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•BIN•EVEN・EXP・1NT■LCM・MINVERSE・MMULT・Pl・POWER•RANDBETWEEN・ROMAN・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・IC・SEARCH或SEARC•valueSUBSTITUTEWTDECHAR・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・NORMDIST・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・TRANSPOSE・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・WORKDAYS・NOW・SECOND・TIME・TIMEVaLUE・TODAY・WEEKDAY・WEEKNL'M・WORKDAY•YEAR •YEARFRAC八、外部函数(2条)・EUROCONVERT・、工程函数(39条)・BESSELI・BESSELJ・BESSELK・BESSELY・BIN2DEC•BIN2HEX・PLEX・CONVERT・DEC2BIN・DEC2HEX・DEC2OCT•DELTA・ERF・ERFC・GESTEP・HEX2BIN・HEX2DEC・HEX2OCT・1MABS・IMAGINARY・1MARGUMENT・MCONJUGATE・1MCOS・TMDTV•TMEXP・TMLN•TML0G10・•TMPOWER•1MPR0DUCT•1MREAL・1MS1N・1MSQRT・1MSUB・1MSUM・OCT2BIN・OCT2DEC・0CT2HEX十、财务函数(52条)・ACCRINT・ACC