Excel函数速查表
2006-08-16 21:18:29 来源：WEB开发网
核心提示：一、数据库函数·DAVERAGE·DCOUNT·DCOUNTA·DGET·DMAX·DMIN·DPRODUCT·DSTDEV·DSTDEVP·DSUM·DVAR&mi
一、数据库函数
| ·DAVERAGE | ·DCOUNT | ·DCOUNTA | ·DGET | ·DMAX | ·DMIN |
| ·DPRODUCT | ·DSTDEV | ·DSTDEVP | ·DSUM | ·DVAR | ·DVARP |
| ·GETPIVOTDATA | | | | | |
二、日期与时间函数
| ·DATE | ·DATEVaLUE | ·DAY | ·DAYS360 | ·EDATE | ·EOMONTH |
| ·HOUR | ·MINUTE | ·MONTH | ·NETWORKDAYS | ·NOW | ·SECOND |
| ·TIME | ·TIMEVaLUE | ·TODAY | ·WEEKDAY | ·WEEKNUM | ·WORKDAY |
| ·YEAR | ·YEARFRAC | | | | |
三、外部函数
| ·EUROCONVERT |
·SQL.REQUEST |
| | | |
四、工程函数
| ·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 | | | |
五、财务函数
| ·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 |
|
|
六、信息函数
| ·CELL |
·ERROR.TYPE |
·INFO |
·IS类 |
·ISEVEN |
·ISODD |
| ·N |
·NA |
·TYPE |
|
|
|
七、逻辑运算符
| ·AND |
·FALSE |
·IF |
·NOT |
·OR |
·TRUE |
八、查找和引用函数
| ·ADDRESS |
·AREAS |
·CHOOSE |
·COLUMN |
·COLUMNS |
·HLOOKUP |
| ·HYPERLINK |
·INDEX |
·INDIRECT |
·LOOKUP |
·MATCH |
·OFFSET |
| ·ROW |
·ROWS |
·RTD |
·TRANSPOSE |
·VLOOKUP |
|
九、数学和三角函数
| ·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 |
十、统计函数
| ·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 |
|
|
|
|
十一、文本和数据函数
| ·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 |
|
|
赞助商链接
中查找“Excel函数速查表”更多相关内容
中查找“Excel函数速查表”更多相关内容
