您现在的位置： Excel函数速查表
Office学院 2006-08-16
一、数据库函数
| ·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 |
四、工程函数
五、财务函数
六、信息函数
| ·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 |
