Excel函数用途、参数、用法速查表
发布时间：2016-12-19 来源：查字典编辑
摘要：（按Ctrl+F搜索）一、数据库函数（13条）DAVERAGEDCOUNTDCOUNTADGETDMAXDMINDPRODUCTDSTDEV...
（按Ctrl+F搜索）
| 一、数据库函数（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条） |
| DATE | DATEVaLUE | DAY | DAYS360 | EDATE | | EOMONTH | HOUR | MINUTE | MONTH | NETWORKDAYS | | NOW | SECOND | TIME | TIMEVaLUE | TODAY | | WEEKDAY | WEEKNUM | WORKDAY | YEAR | YEARFRAC | 0 |
