日期和时间类别:
DATE
DATEDIF
DATEVALUE
DAY
DAYS360
HOUR
MINUTE
MONTH
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
YEAR
财务类别:
DDB
FV
IPMT
ISPMT
NPER
NPV
PMT
PPMT
PV
RATE
SLN
SYD
信息类别:
IS
Me
逻辑类别:
AND
FALSE
IF
NOT
OR
TRUE
查阅和参考类别:
CHOOSE
数学函数和三角函数类别:
ABS
ACOS
ACOSH
ASIN
ASINH
ATAN
ATAN2
ATANH
CEILING
COS
COSH
DEGREES
EVEN
EXP
FACT
FLOOR
INT
LN
LOG
LOG10
MOD
ODD
PI
POWER
PRODUCT
RADIANS
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SIGN
SIN
SINH
SQRT
SUM
SUMSQ
TAN
TANH
TRUNC
统计类别:
AVEDEV
AVERAGE
AVERAGEA
BETADIST
BETAINV
BINOMDIST
CHIDIST
CHIINV
CONFIDENCE
COUNT
COUNTA
CRITBINOM
DEVSQ
EXPONDIST
FDIST
FINV
FISHER
FISHERINV
GAMMADIST
GAMMAINV
GAMMALN
GEOMEAN
HARMEAN
HYPGEOMDIST
KURT
LOGINV
LOGNORMDIST
MAX
MAXA
MEDIAN
MIN
MINA
MODE
NEGBINOMDIST
NORMDIST
NORMINV
NORMSDIST
NORMSINV
POISSON
SKEW
STANDARDIZE
STDEV
STDEVA
STDEVP
STDEVPA
TDIST
TINV
VAR
VARA
VARP
VARPA
WEIBULL
文本和数据类别:
ASC
CHAR
CLEAN
CODE
CONCATENATE
DOLLAR
EXACT
FIND
FIXED
LEFT
LEN
LOWER
MID
PROPER
REPLACE
REPT
RIGHT
SEARCH
T
TEXT
TRIM
UPPER
USDOLLAR
VALUE
计算栏函数列表
![](https://img2024.cnblogs.com/blog/35695/202408/35695-20240826070647288-243310440.jpg)