欢迎来到天天文库
浏览记录
ID:15029135
大小:118.34 KB
页数:56页
时间:2018-08-01
《excel函数速查手册》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、EXCEL函数速查手册一、数学和三角函数(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·R
2、OUND·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·CO
3、VAR·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·NOR
4、MSINV·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·FI
5、ND·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 四、逻辑运算符(6条)·AND·FALSE·IF·NOT·OR·TRUE五、查找和引用函数(17条)·ADDRESS·AREAS·CHOOSE·COLUMN·COLUMNS·HLOOKUP·HYPERLINK·INDEX·IND
6、IRECT·LOOKUP·MATCH·OFFSET·ROW·ROWS·RTD·TRANSPOSE·VLOOKUP 六、数据库函数(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·TIMEV
7、aLUE·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·MC
8、ONJUGATE·IMCOS·IMDIV·IMEXP·IMLN·IMLOG10·IMLOG2·IMPOWER·IMPRODUCT·IMREAL·IMSIN·IMSQRT·IMSU
此文档下载收益归作者所有