2024年4月3日发(作者：)

Excel函数用途、参数、用法速查表〔按Ctrl+F搜索〕

一、数据库函数〔13条〕

DAVERAGE

DMIN

DVAR

DCOUNT

DPRODUCT

DVARP

DCOUNTA

DSTDEV

DGET

DSTDEVP

DMAX

DSUM

GETPIVOTDATA

二、日期与时间函数〔20条〕

DATE

EOMONTH

NOW

WEEKDAY

DATEVaLUE

HOUR

SECOND

WEEKNUM

DAY

MINUTE

TIME

WORKDAY

DAYS360

MONTH

TIMEVaLUE

YEAR

EDATE

NETWORKDAYS

TODAY

YEARFRAC

三、外部函数〔2条〕

EUROCONVERT

四、工程函数〔39条〕

BESSELI

BIN2HEX

DEC2HEX

GESTEP

IMAGINARY

IMEXP

IMPRODUCT

IMSUM

BESSELJ

BIN2OCT

DEC2OCT

HEX2BIN

IMARGUMENT

IMLN

IMREAL

OCT2BIN

BESSELK

COMPLEX

DELTA

HEX2DEC

MCONJUGATE

IMLOG10

IMSIN

OCT2DEC

BESSELY

CONVERT

ERF

HEX2OCT

IMCOS

IMLOG2

IMSQRT

OCT2HEX

BIN2DEC

DEC2BIN

ERFC

IMABS

IMDIV

IMPOWER

IMSUB

五、财务函数〔52条〕

ACCRINT

COUPDAYS

CUMPRINC

DOLLARFR

INTRATE

MIRR

ODDFYIELD

PRICE

RECEIVED

TBILLYIELD

YIELDDISC

ACCRINTM

COUPDAYSNC

DB

DURATION

IPMT

NOMINAL

ODDLPRICE

PRICEDISC

SLN

VDB

YIELDMAT

AMORDEGRC

COUPNUM

DDB

EFFECT

IRR

NPER

ODDLYIELD

PRICEMAT

SYD

XIRR

AMORLINC

COUPPCD

DISC

FV

ISPMT

NPV

PMT

PV

TBILLEQ

XNPV

COUPDAYBS

CUMIPMT

DOLLARDE

FVSCHEDULE

MDURATION

ODDFPRICE

PPMT

RATE

TBILLPRICE

YIELD

学习文档 仅供参考

六、信息函数〔9条〕

CELL

ISODD

N

INFO

NA

IS 类

TYPE

ISEVEN

七、逻辑运算符〔6条〕

AND FALSE IF NOT OR TRUE

八、查找和引用函数〔17条〕

ADDRESS

HLOOKUP

MATCH

TRANSPOSE

AREAS

HYPERLINK

OFFSET

VLOOKUP

CHOOSE

INDEX

ROW

COLUMN

INDIRECT

ROWS

COLUMNS

LOOKUP

RTD

九、数学和三角函数〔60条〕

ABS

ATAN

COS

EXP

INT

MDETERM

MULTINOMIAL

QUOTIENT

ROUND

SIN

SUM

SUMX2PY2

ACOS

ATAN2

COSH

FACT

LCM

MINVERSE

ODD

RADIANS

ROUNDDOWN

SINH

SUMIF

SUMXMY2

ACOSH

ATANH

COUNTIF

FACTDOUBLE

LN

MMULT

PI

RAND

ROUNDUP

SQRT

SUMPRODUCT

TAN

ASIN

CEILING

DEGREES

FLOOR

LOG

MOD

POWER

RANDBETWEEN

SERIESSUM

SQRTPI

SUMSQ

TANH

ASINH

COMBIN

EVEN

GCD

LOG10

MROUND

PRODUCT

ROMAN

SIGN

SUBTOTAL

SUMX2MY2

TRUNC

十、统计函数〔80条〕

AVEDEV

BINOMDIST

CORREL

COVAR

FINV

FTEST

GROWTH

LARGE

MAX

MODE

NORMSINV

POISSON

SKEW

AVERAGE

CHIDIST

COUNT

CRITBINOM

FISHER

GAMMADIST

HARMEAN

LINEST

MAXA

NEGBINOMDIST

PEARSON

PROB

SLOPE

AVERAGEA

CHIINV

COUNTA

DEVSQ

FISHERINV

GAMMAINV

HYPGEOMDIST

LOGEST

MEDIAN

NORMDIST

PERCENTILE

QUARTILE

SMALL

学习文档 仅供参考

BETADIST

CHITEST

COUNTBLANK

EXPONDIST

FORECAST

GAMMALN

INTERCEPT

LOGINV

MIN

NORMSINV

PERCENTRANK

RANK

STANDARDIZE

BETAINV

CONFIDENCE

COUNTIF

FDIST

FREQUENCY

GEOMEAN

KURT

LOGNORMDIST

MINA

NORMSDIST

PERMUT

RSQ

STDEV