首字母 | 函数 |
---|---|
A | ABS ACOS ACOSH ACOT ACOTH ADDRESS AGGREGATE ARABIC AREAS ASIN ASINH ATAN ATAN2 ATANH AVEDEV AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS |
B | BASE BETA.DIST BETA.INV BETADIST BINOM.DIST BINOM.DIST.RAN BINOM.INV BINOMDIST |
C | CEILING CEILING.MATH CEILING.PRECISE CHAR CHISO,DIST CHISQ.DIST.RT CHISQ.INV CHISQ.INV.RT CHISQ.TEST CHOOSE CLEAN CODE COLUMN COLUMNS COMBIN COMBINA CONCATENATE CONFIDENCE.NO CONFIDENCE.T COS COSH COT COTH COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS COVAR COVARIANCE.P COVARIANCE.S CRITBINOM CSC CSCH CAMOUNT |
D | DATE DATEVALUE DAY DAYS DAYS360 DECIMAL DEGREES DOLLAR |
E | EDATE EOMONTH ERF ERFC EVEN EXACT EXP EXPON.DIST |
F | F.DIST F.DIST.RT F.INV F.INV.RT F.TEST FACT FACTDOUBLE FALSE FIND FISHER FISHERINV FIXED FLOOR FLOOR.MATH FLOOR.PRECISE FORECAST FORMULATEXT FREQUENCY |
G | GAMMA GAMMA.DIST GAMMA.INV GAMMALN GAUSS GCD GEOMEAN |
H | HARMEAN HLOOKUP HOUR HYPERLINK |
I | IF IFERROR NDEX INDIRECT INT INTERCEPT SBLANK ISERR ISERROR SEVEN ISLOGICAL ISNA SNONTEXT SNUMBER ISO.CEILING SODD SOWEEKNUM ISREF STEXT |
K | KURT |
L | LARGE LCM LEFT LEN LINEST LN LOG LOG10 LOGEST LOGNORM.DIST LOGNORM.INV LOWER |
M | MATCH MAX MDETERM MEDIAN MID MIN MINUTE MINVERSE MMULT MOD MODE.MULT MODE.SNGL MONTH MROUND MULTINOMIAL MUNIT |
N | N NA NEGBINOM.DIST NEGBINOMDIST NETWORKDAYS NORM.DIST NORM |NV NORM.S.DIST NORM.S.INV NOT NOW |
O | ODD OFFSET |
P | PEARSON PERCENTLE PERCENTILE.EXC PERCENTILE,INC PERCENTRANK PERCENTRANK.E PERCENTRANKI PHI PI POISSON.DIST POWER PROB PRODUCT PROPER |
Q | QUARTILE QUARTILE.EXC QUARTILE.INC QUOTIENT |
R | RADIANS RAND RANDBETWEEN RANK RANKAVG RANK.EQ REPLACE REPT RIGHT ROMAN ROUNDUP ROW ROWS RSQ ROUNDDOWN |
S | SEARCH SEC SECH SECOND SERIESSUM SIGN SIN SINH SLOPE SMALL SQRT SQRTPI STDEV.P STDEV.S STEYX SUBSTITUTE SUBTOTAL SUM SUMIF SUMIFS SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 |
T | T T.DIST T.DIST.2T T.DIST.RT T.INV T.INV.2T T.TEST TAN TANH TEXT TIME TIMEVALUE TODAY TRANSPOSE TRIM TRIMMEAN TRUE |
U | UNICHAR UNICODE UPPER |
V | VALUE VAR.P VAR.S VLOOKUP |
W | WEEKDAY WEEKNUM WORKDAY |
Y | YEAR YEARFRAC |
© 版权声明
THE END