国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 辦公 > Excel > 正文

Excel函數(shù)用途、參數(shù)、用法速查表

2024-08-23 19:50:52
字體:
來源:轉載
供稿:網友

(按Ctrl+F搜索)

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

DAVERAGE

DCOUNT

DCOUNTA

DGET

DMAX

DMIN

DPRODUCT

DSTDEV

DSTDEVP

DSUM

DVAR

DVARP

GETPIVOTDATA

二、日期與時間函數(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
五、財務函數(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
七、邏輯運算符(6條)
AND FALSE IF NOT OR TRUE
八、查找和引用函數(shù)(17條)
ADDRESS AREAS CHOOSE COLUMN COLUMNS
HLOOKUP HYPERLINK INDEX INDIRECT LOOKUP
MATCH OFFSET ROW ROWS RTD
TRANSPOSE VLOOKUP
九、數(shù)學和三角函數(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)計函數(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

發(fā)表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發(fā)表
主站蜘蛛池模板: 景泰县| 桑植县| 出国| 昭通市| 集安市| 尼玛县| 河北省| 渑池县| 台州市| 彰化市| 赞皇县| 阳城县| 板桥市| 马关县| 思南县| 哈尔滨市| 平原县| 海伦市| 林芝县| 怀宁县| 武穴市| 广南县| 青龙| 遂宁市| 双城市| 桑植县| 湖南省| 海盐县| 金华市| 晋城| 韩城市| 长寿区| 武汉市| 大安市| 鄂伦春自治旗| 遵义县| 曲阳县| 新建县| 南召县| 汉寿县| 肇庆市|