016：EXCEL函数大全(超多函数).xls

首页;目录;函数索引;基础;样;排名总汇;引用查找;MMULT;CharCode;HLOOKUP;AVEDEV;CHOOSE;AREAS;ADDRESS;Sheet14;COLUMNS;FACT;SUM;COUNTIF;SUMIF;AMORLINC;AMORDEGRC;CELL;ACCRINTM;HYPERLINK;反三角函数;反双曲函数;OFFSET;表示逻辑值;DAYS360;DAVERAGE;DATEVALUE;PROPER与JIS;计算最大公约数或最小公倍数;HOUR与MINUTE与SECOND;DSUM;DPRODUCT;DMAX与DMIN;DGET;DCOUNT与DCOUNTA;CLEAN;CODE;DOLLAR与RMB;EXACT;FIND与FINDB;LEFT或LEFTB;FIXED;LEN与LENB;LOWER;MID与MIDB;REPLACE或REPLACEB;EOMONTH;RIGHT与RIGHTB;SEARCH与SEARCHB;TANH与TAN;SUMX2PY2与SUMXMY2与SUMX2MY2;ACCRINT;NOW;RIGHT;VALUE;计算商的整数部分或余数;LEN;MATCH;LEFT与MID;YEAR与MONTH与DAY与WEEKNUM;DATEDIF;INDEX;CONCATENATE;PRODUCT;DATE;转换或检查符号;SUMPRODUCT;SUMSQ;SUBTOTAL;RANK;INT;数值舍入取整;TEXT;IF;AND;OR;NOT;LOOKUP;VLOOKUP;RAND;TODAY;RANDBETWEEN;Asc与WIDECHAR;REPT;WEEKDAY