函數(shù)速查表

十八小子 2010-06-22

展開全文

小編still說：
　　Excel很強(qiáng)！如果你學(xué)會(huì)使用Excel函數(shù)，你會(huì)發(fā)現(xiàn)Excel真的很強(qiáng)！我們做這個(gè)選題，希望能幫助您學(xué)好Excel函數(shù)，用好Excel?，F(xiàn)在已經(jīng)有一個(gè)專題《Excel函數(shù)入門與提高》，以后還會(huì)繼續(xù)豐富這方面的內(nèi)容的，敬請(qǐng)關(guān)注！

到我的主題社區(qū)跟我擺談>>

到Office技巧主題社區(qū)和網(wǎng)友交流>>

到Excel函數(shù)主題社區(qū)和網(wǎng)友交流>>

一、數(shù)據(jù)庫(kù)函數(shù)（13條）

·DAVERAGE	·DCOUNT	·DCOUNTA	·DGET	·DMAX	·DMIN
·DPRODUCT	·DSTDEV	·DSTDEVP	·DSUM	·DVAR	·DVARP
·GETPIVOTDATA

二、日期與時(shí)間函數(shù)（20條）

·DATE	·DATEVaLUE	·DAY	·DAYS360	·EDATE	·EOMONTH
·HOUR	·MINUTE	·MONTH	·NETWORKDAYS	·NOW	·SECOND
·TIME	·TIMEVaLUE	·TODAY	·WEEKDAY	·WEEKNUM	·WORKDAY
·YEAR	·YEARFRAC

三、外部函數(shù)（2條）

·EUROCONVERT

·SQL.REQUEST

四、工程函數(shù)（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

五、財(cái)務(wù)函數(shù)（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

六、信息函數(shù)（9條）

·CELL	·ERROR.TYPE	·INFO	·IS類	·ISEVEN	·ISODD
·N	·NA	·TYPE

七、邏輯運(yùn)算符（6條）

八、查找和引用函數(shù)（17條）

·ADDRESS	·AREAS	·CHOOSE	·COLUMN	·COLUMNS	·HLOOKUP
·HYPERLINK	·INDEX	·INDIRECT	·LOOKUP	·MATCH	·OFFSET
·ROW	·ROWS	·RTD	·TRANSPOSE	·VLOOKUP

九、數(shù)學(xué)和三角函數(shù)（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

十、統(tǒng)計(jì)函數(shù)（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

十一、文本和數(shù)據(jù)函數(shù)（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

到Office技巧主題社區(qū)和網(wǎng)友交流>>

到Excel函數(shù)主題社區(qū)和網(wǎng)友交流>>

閱讀關(guān)于 excel excel函數(shù) excel函數(shù)教程的全部文章

本站是提供個(gè)人知識(shí)管理的網(wǎng)絡(luò)存儲(chǔ)空間，所有內(nèi)容均由用戶發(fā)布，不代表本站觀點(diǎn)。請(qǐng)注意甄別內(nèi)容中的聯(lián)系方式、誘導(dǎo)購(gòu)買等信息，謹(jǐn)防詐騙。如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請(qǐng)點(diǎn)擊一鍵舉報(bào)。

轉(zhuǎn)藏 分享

QQ空間 QQ好友新浪微博微信

獻(xiàn)花（0） +1

來自：十八小子 > 《數(shù)據(jù)公式》

舉報(bào)/認(rèn)領(lǐng)