EXCEL函数速查一览(史上最权威,Excelhome整理)

·DAVERAGE·DCOUNT·DCOUNTA·DPRODUCT·DSTDEV·DSTDEVP·GETPIVOTDATA·DATE ·DATEVaLUE·DAY·HOUR·MINUTE·MONTH·TIME·TIMEVaLUE·TODAY·YEAR·YEARFRAC·EUROCONVERT·SQL.REQUEST·BESSELI·BESSELJ·BESSELK·BIN2OCT·COMPLEX·CONVERT·DELTA·ERF·ERFCExcel 2003函数速查一览一、数据库函数（二、日期与时间函数三、外部函数（四、工程函数（·HEX2OCT·IMABS·IMAGINARY·IMDIV·IMEXP·IMLN·IMPRODUCT·IMREAL·IMSIN·OCT2BIN·OCT2DEC·OCT2HEX·ACCRINT·ACCRINTM·AMORDEGRC·COUPDAYSNC·COUPNUM·COUPPCD·DDB·DISC·DOLLARDE·FV·FVSCHEDULE·INTRATE·MDURATION·MIRR·NOMINAL·ODDFYIELD·ODDLPRICE·ODDLYIELD·PRICEDISC·PRICEMAT·PV·SYD·TBILLEQ·TBILLPRICE·XNPV·YIELD·YIELDDISC·CELL ·ERROR.TYPE ·INFO ·N·NA ·TYPE 五、财务函数（52条）六、信息函数（9条）·AND·FALSE·IF·ADDRESS·AREAS·CHOOSE·HYPERLINK·INDEX·INDIRECT·ROW·ROWS·RTD·ABS·ACOS·ACOSH·ATAN2·ATANH·CEILING·COUNTIF·DEGREES·EVEN·FLOOR·GCD·INT·LOG10·MDETERM·MINVERSE·MULTINOMIAL·ODD·PI·RADIANS·RAND·RANDBETWEEN·ROUNDUP·SERIESSUM·SIGN·SQRTPI·SUBTOTAL·SUM九、数学和三角函数60条）七、逻辑运算符八、查找和引用函数17条）·SUMX2MY2·SUMX2PY2·SUMXMY2·AVEDEV·AVERAGE·AVERAGEA·CHIDIST·CHIINV·CHITEST·COUNTA·COUNTBLANK·COUNTIF·EXPONDIST·FDIST·FINV·FREQUENCY·FTEST·GAMMADIST·GROWTH·HARMEAN·HYPGEOMDIST·LINEST·LOGEST·LOGINV·MEDIAN·MIN·MINA·NORMSINV·NORMSDIST·NORMSINV·PERMUT·POISSON·PROB·SKEW·SLOPE·SMALL·STDEVP·STDEVPA·STEYX·TRIMMEAN·TTEST·VAR·WEIBULL·ZTEST十、统计函数（80条）十一、文本和数据函28条）·ASC·CHAR·CLEAN·EXACT·FIND·FINDB·LEN 或 LENB·LOWER·MID 或 MIDB·REPT·RIGHT 或 RIGHTB·SEARCH 或 SEARC·TRIM·UPPER·value ·DGET·DMAX·DMIN·DSUM·DVAR·DVARP·DAYS360·EDATE·EOMONTH·NETWORKDAYS·NOW·SECOND·WEEKDAY·WEEKNUM·WORKDAY·BESSELY·BIN2DEC·BIN2HEX·DEC2BIN·DEC2HEX·DEC2OCT·GESTEP·HEX2BIN·HEX2DEC3函数速查一览函数（13条）间函数（20条）函数（2条）函数（39条）·IMARGUMENT·MCONJUGATE·IMCOS·IMLOG10·IMLOG2·IMPOWER·IMSQRT·...