全部顯示
全部隱藏
函數
函數
若需在公式中使用函數,以用於計算欄位及預設值的相關資訊,請參閱下列主題。
日期及時間
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
©2003 Microsoft Corporation. All rights reserved.