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函数速查表”更多相关内容