1116

Excel函?速查表2005-08-10 09:08　作者：程欣出?：天极?任??：stillhttp://soft.yesky.com/office/188/2065188.shtml 一、?据?函?（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    

1