| 一、数据库函数（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 |
TIMEVaLUE |
TODAY |
| WEEKDAY |
WEEKNUM |
WORKDAY |
YEAR |
YEARFRAC | |
| 三、外部函数（2条） |
|
|
| 四、工程函数（39条） |
| BESSELI |
BESSELJ |
BESSELK |
BESSELY |
BIN2DEC |
| BIN2HEX |
BIN2OCT |
COMPLEX |
CONVERT |
DEC2BIN |
| DEC2HEX |
DEC2OCT |
DELTA |
ERF |
ERFC |
| GESTEP |
HEX2BIN |
HEX2DEC |
HEX2OCT |
IMABS |
| IMAGINARY |
IMARGUMENT |
MCONJUGATE |
IMCOS |
IMDIV |
| IMEXP |
IMLN |
IMLOG10 |
IMLOG2 |
IMPOWER |
| IMPRODUCT |
IMREAL |
IMSIN |
IMSQRT |
IMSUB |
| IMSUM |
OCT2BIN |
OCT2DEC |
OCT2HEX |
| |
| 五、财务函数（52条） |
| ACCRINT |
ACCRINTM |
AMORDEGRC |
AMORLINC |
COUPDAYBS |
| COUPDAYS |
COUPDAYSNC |
COUPNUM |
COUPPCD |
CUMIPMT |
| CUMPRINC |
DB |
DDB |
DISC |
DOLLARDE |
| DOLLARFR |
DURATION |
EFFECT |
FV |
FVSCHEDULE |
| INTRATE |
IPMT |
IRR |
ISPMT |
MDURATION |
| MIRR |
NOMINAL |
NPER |
NPV |
ODDFPRICE |
| ODDFYIELD |
ODDLPRICE |
ODDLYIELD |
PMT |
PPMT |
| PRICE |
PRICEDISC |
PRICEMAT |
PV |
RATE |
| RECEIVED |
SLN |
SYD |
TBILLEQ |
TBILLPRICE |
| TBILLYIELD |
VDB |
XIRR |
XNPV |
YIELD |
| YIELDDISC |
YIELDMAT |
|
|
| |
| 六、信息函数（9条） |
| CELL |
ERROR.TYPE |
INFO |
IS 类 |
ISEVEN |
| ISODD |
N |
NA |
TYPE |
| |
| 七、逻辑运算符（6条） |
|
|
| 八、查找和引用函数（17条） |
| ADDRESS |
AREAS |
CHOOSE |
COLUMN |
COLUMNS |
| HLOOKUP |
HYPERLINK |
INDEX |
INDIRECT |
LOOKUP |
| MATCH |
OFFSET |
ROW |
ROWS |
RTD |
| TRANSPOSE |
VLOOKUP |
|
|
| |
| 九、数学和三角函数（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 |
| ROUND |
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 |
| COVAR |
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 |
| NORMSINV |
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 |
FIND |
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 |
|
| |
管理资源吧