The built-in evaluator supports arithmetic, cell and range references, defined-name ranges, and these WideString,指定要計算的運算式字串 groups:
text WideString,指定要計算的運算式字串s (
TRIM,
PROPER,
CLEAN,
CHAR,
CODE,
T,
EXACT,
REPT,
FIND,
SEARCH,
SUBSTITUTE,
REPLACE);
date WideString,指定要計算的運算式字串s (
EDATE,
EOMONTH,
DATEDIF,
YEARFRAC,
DAYS,
WEEKNUM,
ISOWEEKNUM);
workday WideString,指定要計算的運算式字串s (
WORKDAY,
NETWORKDAYS);
engineering/base-conversion WideString,指定要計算的運算式字串s (
DEC2BIN,
DEC2HEX,
DEC2OCT,
BIN2DEC,
BIN2HEX,
BIN2OCT,
OCT2DEC,
OCT2BIN,
OCT2HEX,
HEX2DEC,
HEX2BIN,
HEX2OCT,
BASE,
DECIMAL,
ARABIC);
bitwise WideString,指定要計算的運算式字串s (
BITAND,
BITOR,
BITXOR,
BITLSHIFT,
BITRSHIFT);
statistical WideString,指定要計算的運算式字串s (
VAR,
VARP,
STDEV,
STDEVP,
MODE,
VARA,
VARPA,
STDEVA,
STDEVPA);
aggregate WideString,指定要計算的運算式字串s (
PRODUCT,
SUMSQ);
math WideString,指定要計算的運算式字串s (
GCD,
LCM,
MROUND,
QUOTIENT,
MULTINOMIAL)
Custom or unsupported worksheet WideString,指定要計算的運算式字串s can still be resolved through
此範例計算文字運算式