厦门国税规章 | 税收法规 | 税法解读 | 福州市社平工资 | 漳州市社平工资 | 厦门会计指南 | 新税收优惠 | 企业所得税优惠 | ..新增值税税率 | 个人所得税计算器
厦门地税规章 | 会计法规 | 准则解读 | 泉州市社平工资 | 龙岩市社平工资 | 税收筹划实务 | 增值税优惠 | 个人所得税优惠 | 土地增值税税率 | 企业所得税法
厦门政府规章 | 会计法规 | 税法解读 | 宁德市社平工资 | 三明市社平工资 | 最新财税法规 | 营业税优惠 | 土地增值税优惠 | 个人所得税税率 |
福建税收法规 | 会计法规 | 财会解读 | 莆田市社平工资 | 南平市社平工资 | 税收基本法规 | 房产税优惠 | ..2016税收优惠 | 企业所得税税率 |

Excel函数速查表
2010-11-01 10:24:35   来源:   评论:0 点击:

一、数据库函数(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条)
·EUROCONVERT ·SQL.REQUEST        
四、工程函数(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条)
·AND ·FALSE ·IF ·NOT ·OR ·TRUE
八、查找和引用函数(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  

相关热词搜索:Excel 函数 速查表

上一篇:第一页
下一篇:最后一页

分享到: 收藏
频道总排行
频道本月排行