国产探花免费观看_亚洲丰满少妇自慰呻吟_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ā)表
主站蜘蛛池模板: 怀宁县| 嘉黎县| 衡山县| 长白| 南部县| 富裕县| 花垣县| 澄江县| 杂多县| 津南区| 儋州市| 东兰县| 清远市| 微山县| 民丰县| 汉沽区| 永福县| 林西县| 岐山县| 浑源县| 宜兰市| 分宜县| 新密市| 株洲市| 呼图壁县| 安多县| 讷河市| 兴宁市| 苗栗县| 都匀市| 华蓥市| 武夷山市| 宜城市| 新建县| 桓仁| 西乌| 太和县| 邵东县| 淮阳县| 潼南县| 巴中市|