2.5.98.10 Ftab
The Ftab structure specifies a function that can be called from a formula (section 2.2.2). The definition of each function specifies the function name and the valid sequence of parameters.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
iftab |
|||||||||||||||||||||||||||||||
iftab (2 bytes): An unsigned integer that specifies the function to be called. It MUST be a value from the following table.
-
The elements ref and val (section 2.5.98.88) are specified in section 2.5.98.88.
-
Value
Meaning
Parameters
0x0000
COUNT
count-params = (ref / val) *254(ref / val)
0x0001
IF
if-params = val *2(ref / val)
if-worksheet-params = val 1*2(ref / val)
If the formula (section 2.2.2) containing this structure is contained by a CellParsedFormula (section 2.5.98.4) that is contained by a Macro Sheet part (section 2.1.7.32) then the if-params rule MUST be used.
If the formula (section 2.2.2) containing this structure is contained by a NameParsedFormula (section 2.5.98.12) then the if-params rule MUST be used.
Otherwise, the if-worksheet-params rule MUST be used.
0x0002
ISNA
isna-params = val
0x0003
ISERROR
iserror-params = val
0x0004
SUM
sum-params = (ref / val) *254(ref / val)
0x0005
AVERAGE
average-params = (ref / val) *254(ref / val)
0x0006
MIN
min-params = (ref / val) *254(ref / val)
0x0007
MAX
max-params = (ref / val) *254(ref / val)
0x0008
ROW
row-params = [ref]
0x0009
COLUMN
column-params = [ref]
0x000A
NA
This function takes no parameters.
0x000B
NPV
npv-params = val (ref / val) *253(ref / val)
0x000C
STDEV
stdev-params = (ref / val) *254(ref / val)
0x000D
DOLLAR
dollar-params = val [val]
0x000E
FIXED
fixed-params = val [val [val]]
0x000F
SIN
sin-params = val
0x0010
COS
cos-params = val
0x0011
TAN
tan-params = val
0x0012
ATAN
atan-params = val
0x0013
PI
This function takes no parameters.
0x0014
SQRT
sqrt-params = val
0x0015
EXP
exp-params = val
0x0016
LN
ln-params = val
0x0017
LOG10
log10-params = val
0x0018
ABS
abs-params = val
0x0019
INT
int-params = val
0x001A
SIGN
sign-params = val
0x001B
ROUND
round-params = val val
0x001C
LOOKUP
lookup-params = val (ref / val) [ref / val]
0x001D
INDEX
index-params = (ref / val) val *2(val)
0x001E
REPT
rept-params = val val
0x001F
MID
mid-params = val val val
0x0020
LEN
len-params = val
0x0021
VALUE
value-params = val
0x0022
TRUE
This function takes no parameters.
0x0023
FALSE
This function takes no parameters.
0x0024
AND
and-params = (ref / val) *254(ref / val)
0x0025
OR
or-params = (ref / val) *254(ref / val)
0x0026
NOT
not-params = val
0x0027
MOD
mod-params = val val
0x0028
DCOUNT
dcount-params = ref (ref / val) (ref / val)
0x0029
DSUM
dsum-params = ref (ref / val) (ref / val)
0x002A
DAVERAGE
daverage-params = ref (ref / val) (ref / val)
0x002B
DMIN
dmin-params = ref (ref / val) (ref / val)
0x002C
DMAX
dmax-params = ref (ref / val) (ref / val)
0x002D
DSTDEV
dstdev-params = ref (ref / val) (ref / val)
0x002E
VAR
var-params = (ref / val) *254(ref / val)
0x002F
DVAR
dvar-params = ref (ref / val) (ref / val)
0x0030
TEXT
text-params = val val
0x0031
LINEST
linest-params = (ref / val) [(ref / val) *2(ref / val)]
0x0032
TREND
trend-params = (ref / val) [(ref / val) [(ref / val) [ref / val]]]
0x0033
LOGEST
logest-params = (ref / val) [(ref / val) *2(ref / val)]
0x0034
GROWTH
growth-params = (ref / val) [(ref / val) [(ref / val) [ref / val]]]
0x0035
GOTO
goto-params = ref
0x0036
HALT
halt-params = [val]
0x0037
RETURN
return-params = [ref / val]
0x0038
PV
pv-params = val val val *2(val)
0x0039
FV
fv-params = val val val *2(val)
0x003A
NPER
nper-params = val val val *2(val)
0x003B
PMT
pmt-params = val val val *2(val)
0x003C
RATE
rate-params = val val val *3(val)
0x003D
MIRR
mirr-params = (ref / val) val val
0x003E
IRR
irr-params = (ref / val) [val]
0x003F
RAND
This function takes no parameters.
0x0040
MATCH
match-params = val (ref / val) [ref / val]
0x0041
DATE
date-params = val val val
0x0042
TIME
time-params = val val val
0x0043
DAY
day-params = val
0x0044
MONTH
month-params = val
0x0045
YEAR
year-params = val
0x0046
WEEKDAY
weekday-params = val [val]
0x0047
HOUR
hour-params = val
0x0048
MINUTE
minute-params = val
0x0049
SECOND
second-params = val
0x004A
NOW
This function takes no parameters.
0x004B
AREAS
areas-params = ref
0x004C
ROWS
rows-params = (ref / val)
0x004D
COLUMNS
columns-params = (ref / val)
0x004E
OFFSET
offset-params = ref val val *2(val)
0x004F
ABSREF
absref-params = val ref
0x0050
RELREF
relref-params = ref ref
0x0051
ARGUMENT
argument-params = [val [(ref / val) [ref]]]
0x0052
SEARCH
search-params = val val [val]
0x0053
TRANSPOSE
transpose-params = val
0x0054
ERROR
error-params = [val [ref / val]]
0x0055
STEP
This function takes no parameters.
0x0056
TYPE
type-params = val
0x0057
ECHO
echo-params = [val]
0x0058
SET.NAME
set-name-params = val [ref / val]
0x0059
CALLER
This function takes no parameters.
0x005A
DEREF
deref-params = ref
0x005B
WINDOWS
windows-params = [val [val]]
0x005D
DOCUMENTS
documents-params = [val [val]]
0x005E
ACTIVE.CELL
This function takes no parameters.
0x005F
SELECTION
This function takes no parameters.
0x0060
RESULT
result-params = [val]
0x0061
ATAN2
atan2-params = val val
0x0062
ASIN
asin-params = val
0x0063
ACOS
acos-params = val
0x0064
CHOOSE
choose-params = val (ref / val) *253(ref / val)
0x0065
HLOOKUP
hlookup-params = val (ref / val) (ref / val) [val]
0x0066
VLOOKUP
vlookup-params = val (ref / val) (ref / val) [val]
0x0067
LINKS
links-params = [val [val]]
0x0068
INPUT
input-params = val [val [val [val [val [val [val]]]]]]
0x0069
ISREF
isref-params = (ref / val)
0x006A
GET.FORMULA
get-formula-params = (ref / val)
0x006B
GET.NAME
get-name-params = val [val]
0x006C
SET.VALUE
set-value-params = ref val
0x006D
LOG
log-params = val [val]
0x006E
EXEC
exec-params = val [val *2(val)]
0x006F
CHAR
char-params = val
0x0070
LOWER
lower-params = val
0x0071
UPPER
upper-params = val
0x0072
PROPER
proper-params = val
0x0073
LEFT
left-params = val [val]
0x0074
RIGHT
right-params = val [val]
0x0075
EXACT
right-params = val [val]
0x0076
TRIM
trim-params = val
0x0077
REPLACE
replace-params = val val val val
0x0078
SUBSTITUTE
substitute-params = val val val [val]
0x0079
CODE
code-params = val
0x007A
NAMES
names-params = [val [val [val]]]
0x007B
DIRECTORY
directory-params = [val]
0x007C
FIND
find-params = val val [val]
0x007D
CELL
cell-params = val [ref]
0x007E
ISERR
iserr-params = val
0x007F
ISTEXT
istext-params = val
0x0080
ISNUMBER
isnumber-params = val
0x0081
ISBLANK
isblank-params = val
0x0082
T
t-params = (ref / val)
0x0083
N
n-params = (ref / val)
0x0084
FOPEN
fopen-params = val [val]
0x0085
FCLOSE
fclose-params = val
0x0086
FSIZE
fsize-params = val
0x0087
FREADLN
freadln-params = val
0x0088
FREAD
fread-params = val val
0x0089
FWRITELN
fwriteln-params = val val
0x008A
FWRITE
fwrite-params = val val
0x008B
FPOS
fpos-params = val [val]
0x008C
DATEVALUE
datevalue-params = val
0x008D
TIMEVALUE
timevalue-params = val
0x008E
SLN
sln-params = val val val
0x008F
SYD
syd-params = val val val val
0x0090
DDB
ddb-params = val val val val [val]
0x0091
GET.DEF
get-def-params = val [val [val]]
0x0092
REFTEXT
reftext-params = ref [val]
0x0093
TEXTREF
textref-params = val [val]
0x0094
INDIRECT
indirect-params = val [val]
0x0095
REGISTER
register-params = val [val [val [val [val [val [val [val [val [val *245(val)]]]]]]]]]
0x0096
CALL
call-params = val [(ref / val) *253(ref / val)]
0x0097
ADD.BAR
add-bar-params = [val]
0x0098
ADD.MENU
add-menu-params = val (ref / val) [(ref / val) [val]]
0x0099
ADD.COMMAND
add-command-params = val (ref / val) (ref / val) [(ref / val) [val]]
0x009A
ENABLE.COMMAND
enable-command-params = val val val val [val]
0x009B
CHECK.COMMAND
check-command-params = val val val val [val]
0x009C
RENAME.COMMAND
rename-command-params = val val val val [val]
0x009D
SHOW.BAR
show-bar-params = [val]
0x009E
DELETE.MENU
delete-menu-params = val val [val]
0x009F
DELETE.COMMAND
delete-command-params = val val val [val]
0x00A0
GET.CHART.ITEM
get-chart-item-params = val [val [val]]
0x00A1
DIALOG.BOX
dialog-box-params = (ref / val)
0x00A2
CLEAN
clean-params = val
0x00A3
MDETERM
mdeterm-params = val
0x00A4
MINVERSE
minverse-params = val
0x00A5
MMULT
mmult-params = val val
0x00A6
FILES
files-params = *2(val)
0x00A7
IPMT
ipmt-params = val val val val *2(val)
0x00A8
PPMT
ppmt-params = val val val val *2(val)
0x00A9
COUNTA
counta-params = (ref / val) *254(ref / val)
0x00AA
CANCEL.KEY
cancel-key-params = [val [ref]]
0x00AB
FOR
for-params = val val val [val]
0x00AC
WHILE
while-params = val
0x00AD
BREAK
This function takes no parameters.
0x00AE
NEXT
This function takes no parameters.
0x00AF
INITIATE
initiate-params = val val
0x00B0
REQUEST
request-params = val val
0x00B1
POKE
poke-params = val (ref / val) (ref / val)
0x00B2
EXECUTE
execute-params = val val
0x00B3
TERMINATE
terminate-params = val
0x00B4
RESTART
restart-params = [val]
0x00B5
HELP
help-params = [val]
0x00B6
GET.BAR
get-bar-params = *4(val)
0x00B7
PRODUCT
product-params = (ref / val) *254(ref / val)
0x00B8
FACT
fact-params = val
0x00B9
GET.CELL
get-cell-params = val [ref]
0x00BA
GET.WORKSPACE
get-workspace-params = val
0x00BB
GET.WINDOW
get-window-params = val [val]
0x00BC
GET.DOCUMENT
get-document-params = val [val]
0x00BD
DPRODUCT
dproduct-params = ref (ref / val) (ref / val)
0x00BE
ISNONTEXT
isnontext-params = val
0x00BF
GET.NOTE
get-note-params = [(ref / val) *2(val)]
0x00C0
NOTE
note-params = [val [(ref / val) *2(ref / val)]]
0x00C1
STDEVP
stdevp-params = (ref / val) *254(ref / val)
0x00C2
VARP
varp-params = (ref / val) *254(ref / val)
0x00C3
DSTDEVP
dstdevp-params = ref (ref / val) (ref / val)
0x00C4
DVARP
dvarp-params = ref (ref / val) (ref / val)
0x00C5
TRUNC
trunc-params = val [val]
0x00C6
ISLOGICAL
islogical-params = val
0x00C7
DCOUNTA
dcounta-params = ref (ref / val) (ref / val)
0x00C8
DELETE.BAR
delete-bar-params = val
0x00C9
UNREGISTER
unregister-params = val
0x00CC
USDOLLAR
usdollar-params = val [val]
0x00CD
FINDB
findb-params = val val [val]
0x00CE
SEARCHB
searchb-params = val val [val]
0x00CF
REPLACEB
replaceb-params = val val val val
0x00D0
LEFTB
leftb-params = val [val]
0x00D1
RIGHTB
rightb-params = val [val]
0x00D2
MIDB
midb-params = val val val
0x00D3
LENB
midb-params = val val val
0x00D4
ROUNDUP
roundup-params = val val
0x00D5
ROUNDDOWN
rounddown-params = val val
0x00D6
ASC
asc-params = val
0x00D7
DBCS
dbcs-params = val
0x00D8
RANK
rank-params = val ref [val]
0x00DB
ADDRESS
address-params = val val [val [val [val]]]
0x00DC
DAYS360
days360-params = val val [val]
0x00DD
TODAY
This function takes no parameters.
0x00DE
VDB
vdb-params = val val val val val [val [val]]
0x00DF
ELSE
This function takes no parameters.
0x00E0
ELSE.IF
else-if-params = val
0x00E1
END.IF
This function takes no parameters.
0x00E2
FOR.CELL
for-cell-params = val [(ref / val) [ref / val]]
0x00E3
MEDIAN
median-params = (ref / val) *254(ref / val)
0x00E4
SUMPRODUCT
sumproduct-params = val *254(val)
0x00E5
SINH
sinh-params = val
0x00E6
COSH
cosh-params = val
0x00E7
TANH
tanh-params = val
0x00E8
ASINH
asinh-params = val
0x00E9
ACOSH
acosh-params = val
0x00EA
ATANH
atanh-params = val
0x00EB
DGET
dget-params = ref (ref / val) (ref / val)
0x00EC
CREATE.OBJECT
create-object-params = val (ref / val) [(ref / val) [(ref / val) [(ref / val) [(ref / val) [(ref / val) [(ref / val) [(ref / val) [(ref / val) [ref / val]]]]]]]]]
0x00ED
VOLATILE
volatile-params = [val]
0x00EE
LAST.ERROR
This function takes no parameters.
0x00EF
CUSTOM.UNDO
custom-undo-params = *2(val)
0x00F0
CUSTOM.REPEAT
custom-repeat-params = *3(val)
0x00F1
FORMULA.CONVERT
formula-convert-params = val (ref / val) *3(ref / val)
0x00F2
GET.LINK.INFO
get-link-info-params = val val [val [val]]
0x00F3
TEXT.BOX
text-box-params = val [val *2(val)]
0x00F4
INFO
info-params = val
0x00F5
GROUP
This function takes no parameters.
0x00F6
GET.OBJECT
get-object-params = val [val *3(val)]
0x00F7
DB
db-params = val val val val [val]
0x00F8
PAUSE
pause-params = [val]
0x00FB
RESUME
resume-params = [val]
0x00FC
FREQUENCY
frequency-params = (ref / val) (ref / val)
0x00FD
ADD.TOOLBAR
add-toolbar-params = [val [val]]
0x00FE
DELETE.TOOLBAR
delete-toolbar-params = val
0x00FF
user-defined-or-future-function = cell-params / user-defined-params / user-defined-x-params / future-function
cell-params = (PtgRef / PtgRefN / PtgRef3d / PtgRefErr / PtgRefErr3d) *254(ref / val)
user-defined-params = PtgName *254(ref / val)
-
-
The PtgName (section 2.5.98.60) of the user-defined-params rule MUST NOT be a VALUE_TYPE, as described in section 2.5.98.88.
-
-
If the formula (section 2.2.2) containing this structure is part of a revision as specified in the Formulas overview (section 2.2.2), then this structure MUST be contained by a CellParsedFormula (section 2.5.98.4) or NameParsedFormula (section 2.5.98.12) structure. The rgcb field of the CellParsedFormula or NameParsedFormula MUST have a RevNameTabid (section 2.5.98.85) that corresponds to the PtgName in the user-defined-params rule. The correspondence between RevNameTabid and PtgName is specified by RgbExtra (section 2.5.98.87). The RevNameTabid MUST NOT have a name.st equal to one of the values in the following table.
-
-
If the formula containing this structure is not part of a revision as specified in the Formulas overview (section 2.2.2), the fFutureFunction field of the BrtName (section 2.4.711) record MUST be 0. The BrtName record is specified by the nameindex field of the PtgName of the user-defined-params rule.
-
user-defined-x-params = PtgNameX *254(ref / val)
-
-
The PtgNameX (section 2.5.98.61) of the user-defined-x-params rule MUST NOT be a VALUE_TYPE, as described in section 2.5.98.88.
-
-
Some of the formulas containing this structure are part of a revision as specified in the Formulas overview (section 2.2.2). If so, the RevName (section 2.5.98.83) corresponding to the PtgNameX (as specified by RgbExtra) in the rgcb field of the CellParsedFormula or NameParsedFormula containing this structure MUST NOT have a name.name.st or externName.name.st equal to one of the values in the following table.
-
-
If the formula containing this structure is not part of a revision as specified in the Formulas overview (section 2.2.2), the fFutureFunction field of the BrtName record MUST be 0. The BrtName record is specified by the nameindex field of the PtgNameX of the user-defined-x-params rule.
-
future-function = PtgName future-function-params
-
-
The PtgName of the future-function rule MUST NOT be a VALUE_TYPE, as described in section 2.5.98.88.
-
-
If the formula containing this structure is part of a revision as specified in the Formulas overview (section 2.2.2), then this structure MUST be contained by a CellParsedFormula or NameParsedFormula structure. The rgcb field of the CellParsedFormula or NameParsedFormula MUST have a RevNameTabid that corresponds to the PtgName in the future-function rule. The correspondence between RevNameTabid and PtgName is specified by RgbExtra. The RevNameTabid MUST have a tabid of 0xFFFF, a name.iBuiltin of 0, and a name.st equal to one of the values in the following table.
-
-
If the formula containing this structure is not part of a revision as specified in the Formulas overview (section 2.2.2), the fFutureFunction field of the BrtName record MUST be 1. The BrtName record is specified by the nameindex field of the PtgName of the future-function rule.
-
future-function-params = acot-params / acoth-params / aggregate-params / arabic-params / base-params / betadist-params / beta-inv-params / binom-dist-params / binom-dist-range-params / binom-inv-params / bitand-params / bitlshift-params / bitor-params / bitrshift-params / bitxor-params / bycol-params / byrow-params / ceiling-math-params / ceiling-precise-params / chisq-dist-params / chisq-dist-rt-params / chisq-inv-params / chisq-inv-rt-params / chisq-test-params / choosecols-params / chooserows-params / combina-params / concat-params / confidence-norm-params / confidence-t-params / cot-params / coth-params / covariance-p-params / covariance-s-params / csc-params / csch-params / days-params / decimal-params / drop-params / ecma-ceiling-params / erf-precise-params / erfc-precise-params / expand-params / expon-dist-params / f-dist-params / f-dist-rt-params / f-inv-params / f-inv-rt-params / fieldvalue-params / filter-worksheet-params / filterxml-params / floor-math-params / floor-precise-params / forecast-ets-params / forecast-ets-confint-params / forecast-ets-seasonality-params / forecast-ets-stat-params / forecast-linear-params / formulatext-params / gamma-params / gamma-dist-params / gamma-inv-params / gammaln-precise-params / gauss-params / hstack-params / hypgeom-dist-params / ifna-params / ifs-params / imcosh-params / imcot-params / imcsc-params / imcsch-params / imsec-params / imsech-params / imsinh-params / imtan-params / isformula-params / iso-ceiling-params / isomitted-params / isoweeknum-params / lambda-params / let-params / lognorm-dist-params / lognorm-inv-params / makearray-params / maxifs-params / minifs-params / mode-mult-params / mode-sngl-params / munit-params / negbinom-dist-params / networkdays-intl-params / norm-dist-params / norm-inv-params / norm-s-dist-params / norm-s-inv-params / numbervalue-params / pduration-params / percentile-exc-params / percentile-inc-params / percentrank-exc-params / percentrank-inc-params / permutationa-params / phi-params / poisson-dist-parampqs / pqsource-params / py-params / python-str-params / python-type-params / python-typename-params / quartile-exc-params / quartile-inc-params / querystring-params / randarray-params / rank-avg-params / rank-eq-params / reduce-params / rri-params / scan-params / sec-params / sech-params / sequence-params / sheet-params / sheets-params / skew-p-params / sort-worksheet-params / sortby-params / sort-worksheet-params / stdev-p-params / stdev-s-params / switch-params / t-dist-params / t-dist-twotails-params / t-dist-rt-params / t-inv-params / t-inv-twotails-params / t-test-params / take-params / textafter-params / textbefore-params / textjoin-params / textsplit-params / tocol-params / torow-params / unichar-params / unicode-params / unique-params / var-s-params / var-p-params / vstack-params / webservice-params / weibull-dist-params / workday-intl-params / wrapcols-params / wraprows-params / xlookup-params / xor-params / z-test-params
0x0100
RESET.TOOLBAR
reset-toolbar-params = val
0x0101
EVALUATE
evaluate-params = val
0x0102
GET.TOOLBAR
get-toolbar-params = val [val]
0x0103
GET.TOOL
get-tool-params = val [val [val]]
0x0104
SPELLING.CHECK
spelling-check-params = val [val [val]]
0x0105
ERROR.TYPE
error-type-params = val
0x0106
APP.TITLE
app-title-params = [val]
0x0107
WINDOW.TITLE
window-title-params = [val]
0x0108
SAVE.TOOLBAR
save-toolbar-params = [val [val]]
0x0109
ENABLE.TOOL
enable-tool-params = val val val
0x010A
PRESS.TOOL
press-tool-params = val val val
0x010B
REGISTER.ID
register-id-params = val val [val]
0x010C
GET.WORKBOOK
get-workbook-params = val [val]
0x010D
AVEDEV
avedev-params = (ref / val) *254(ref / val)
0x010E
BETADIST
betadist-params = val val val *2(val)
0x010F
GAMMALN
gammaln-params = val
0x0110
BETAINV
betainv-params = val val val *2(val)
0x0111
BINOMDIST
binomdist-params = val val val val
0x0112
CHIDIST
chidist-params = val val
0x0113
CHIINV
chiinv-params = val val
0x0114
COMBIN
combin-params = val val
0x0115
CONFIDENCE
confidence-params = val val val
0x0116
CRITBINOM
critbinom-params = val val val
0x0117
EVEN
even-params = val
0x0118
EXPONDIST
expondist-params = val val val
0x0119
FDIST
fdist-params = val val val
0x011A
FINV
finv-params = val val val
0x011B
FISHER
fisher-params = val
0x011C
FISHERINV
fisherinv-params = val
0x011D
FLOOR
floor-params = val val
0x011E
GAMMADIST
gammadist-params = val val val val
0x011F
GAMMAINV
gammainv-params = val val val
0x0120
CEILING
ceiling-params = val val
0x0121
HYPGEOMDIST
hypgeomdist-params = val val val val
0x0122
LOGNORMDIST
lognormdist-params = val val val
0x0123
LOGINV
loginv-params = val val val
0x0124
NEGBINOMDIST
negbinomdist-params = val val val
0x0125
NORMDIST
normdist-params = val val val val
0x0126
NORMSDIST
normsdist-params = val
0x0127
NORMINV
norminv-params = val val val
0x0128
NORMSINV
normsinv-params = val
0x0129
STANDARDIZE
standardize-params = val val val
0x012A
ODD
odd-params = val
0x012B
PERMUT
permut-params = val val
0x012C
POISSON
poisson-params = val val val
0x012D
TDIST
tdist-params = val val val
0x012E
WEIBULL
weibull-params = val val val val
0x012F
SUMXMY2
sumxmy2-params = val val
0x0130
SUMX2MY2
sumx2my2-params = val val
0x0131
SUMX2PY2
sumx2py2-params = val val
0x0132
CHITEST
chitest-params = val val
0x0133
CORREL
correl-params = val val
0x0134
COVAR
covar-params = val val
0x0135
FORECAST
forecast-params = val val val
0x0136
FTEST
ftest-params = val val
0x0137
INTERCEPT
intercept-params = val val
0x0138
PEARSON
pearson-params = val val
0x0139
RSQ
rsq-params = val val
0x013A
STEYX
steyx-params = val val
0x013B
SLOPE
slope-params = val val
0x013C
TTEST
ttest-params = val val val val
0x013D
PROB
prob-params = val val val [val]
0x013E
DEVSQ
devsq-params = (ref / val) *254(ref / val)
0x013F
GEOMEAN
geomean-params = (ref / val) *254(ref / val)
0x0140
HARMEAN
harmean-params = (ref / val) *254(ref / val)
0x0141
SUMSQ
sumsq-params = (ref / val) *254(ref / val)
0x0142
KURT
kurt-params = (ref / val) *254(ref / val)
0x0143
SKEW
skew-params = (ref / val) *254(ref / val)
0x0144
ZTEST
ztest-params = (ref / val) val [val]
0x0145
LARGE
large-params = (ref / val) val
0x0146
SMALL
small-params = (ref / val) val
0x0147
QUARTILE
quartile-params = (ref / val) val
0x0148
PERCENTILE
quartile-params = (ref / val) val
0x0149
PERCENTRANK
percentrank-params = (ref / val) val [val]
0x014A
MODE
mode-params = val *254(val)
0x014B
TRIMMEAN
trimmean-params = (ref / val) val
0x014C
TINV
tinv-params = val val
0x014E
MOVIE.COMMAND
movie-command-params = val val val [val]
0x014F
GET.MOVIE
get-movie-params = val val [val]
0x0150
CONCATENATE
concatenate-params = val *254(val)
0x0151
POWER
power-params = val val
0x0152
PIVOT.ADD.DATA
pivot-add-data-params = val val [val [val [val [val *3(val)]]]]
0x0153
GET.PIVOT.TABLE
get-pivot-table-params = val [val]
0x0154
GET.PIVOT.FIELD
get-pivot-field-params = val [val [val]]
0x0155
GET.PIVOT.ITEM
get-pivot-item-params = val [val [val [val]]]
0x0156
RADIANS
radians-params = val
0x0157
DEGREES
degrees-params = val
0x0158
SUBTOTAL
subtotal-params = val ref *253(ref)
0x0159
SUMIF
sumif-params = ref val [ref]
0x015A
COUNTIF
countif-params = ref val
0x015B
COUNTBLANK
countblank-params = ref
0x015C
SCENARIO.GET
scenario-get-params = val [val]
0x015D
OPTIONS.LISTS.GET
options-lists-get-params = val
0x015E
ISPMT
ispmt-params = val val val val
0x015F
DATEDIF
datedif-params = val val val
0x0160
DATESTRING
datestring-params = val
0x0161
NUMBERSTRING
numberstring-params = val val
0x0162
ROMAN
roman-params = val [val]
0x0163
OPEN.DIALOG
open-dialog-params = [val [val [val [val]]]]
0x0164
SAVE.DIALOG
save-dialog-params = [val [val [val [val [val]]]]]
0x0165
VIEW.GET
view-get-params = val [val]
0x0166
GETPIVOTDATA
getpivotdata-params = (ref / val) (ref / val) [val [val *125(val val)]]
0x0167
HYPERLINK
hyperlink-params = val [val]
0x0168
PHONETIC
phonetic-params = ref
0x0169
AVERAGEA
averagea-params = (ref / val) *254(ref / val)
0x016A
MAXA
maxa-params = (ref / val) *254(ref / val)
0x016B
MINA
mina-params = (ref / val) *254(ref / val)
0x016C
STDEVPA
stdevpa-params = (ref / val) *254(ref / val)
0x016D
VARPA
varpa-params = (ref / val) *254(ref / val)
0x016E
STDEVA
stdeva-params = (ref / val) *254(ref / val)
0x016F
VARA
vara-params = (ref / val) *254(ref / val)
0x0170
BAHTTEXT
bahttext-params = val
0x0171
THAIDAYOFWEEK
thaidayofweek-params = val
0x0172
THAIDIGIT
thaidigit-params = val
0x0173
THAIMONTHOFYEAR
thaimonthofyear-params = val
0x0174
THAINUMSOUND
thainumsound-params = val
0x0175
THAINUMSTRING
thainumstring-params = val
0x0176
THAISTRINGLENGTH
thaistringlength-params = val
0x0177
ISTHAIDIGIT
isthaidigit-params = val
0x0178
ROUNDBAHTDOWN
roundbahtdown-params = val
0x0179
ROUNDBAHTUP
roundbahtup-params = val
0x017A
THAIYEAR
thaiyear-params = val
0x017B
RTD
rtd-params = val val val *252(val)
0x017C
CUBEVALUE
cubevalue-params = val [(ref / val) *253(ref / val)]
0x017D
CUBEMEMBER
cubemember-params = val (ref / val) [val]
0x017E
CUBEMEMBERPROPERTY
cubememberproperty-params = val val val
0x017F
CUBERANKEDMEMBER
cuberankedmember-params = val val val [val]
0x0180
HEX2BIN
hex2bin-params = (ref / val) [ref / val]
0x0181
HEX2DEC
hex2dec-params = (ref / val)
0x0182
HEX2OCT
hex2oct-params = (ref / val) [ref / val]
0x0183
DEC2BIN
dec2bin-params = (ref / val) [ref / val]
0x0184
DEC2HEX
dec2hex-params = (ref / val) [ref / val]
0x0185
DEC2OCT
dec2oct-params = (ref / val) [ref / val]
0x0186
OCT2BIN
oct2bin-params = (ref / val) [ref / val]
0x0187
OCT2HEX
oct2hex-params = (ref / val) [ref / val]
0x0188
OCT2DEC
oct2dec-params = (ref / val)
0x0189
BIN2DEC
bin2dec-params = (ref / val)
0x018A
BIN2OCT
bin2oct-params = (ref / val) [ref / val]
0x018B
BIN2HEX
bin2hex-params = (ref / val) [ref / val]
0x018C
IMSUB
imsub-params = (ref / val) (ref / val)
0x018D
IMDIV
imdiv-params = (ref / val) (ref / val)
0x018E
IMPOWER
impower-params = (ref / val) (ref / val)
0x018F
IMABS
imabs-params = (ref / val)
0x0190
IMSQRT
imsqrt-params = (ref / val)
0x0191
IMLN
imln-params = (ref / val)
0x0192
IMLOG2
imlog2-params = (ref / val)
0x0193
IMLOG10
imlog10-params = (ref / val)
0x0194
IMSIN
imsin-params = (ref / val)
0x0195
IMCOS
imcos-params = (ref / val)
0x0196
IMEXP
imexp-params = (ref / val)
0x0197
IMARGUMENT
imargument-params = (ref / val)
0x0198
IMCONJUGATE
imconjugate-params = (ref / val)
0x0199
IMAGINARY
imaginary-params = (ref / val)
0x019A
IMREAL
imreal-params = (ref / val)
0x019B
COMPLEX
complex-params = (ref / val) (ref / val) [ref / val]
0x019C
IMSUM
imsum-params = (ref / val) *254(ref / val)
0x019D
IMPRODUCT
improduct-params = (ref / val) *254(ref / val)
0x019E
SERIESSUM
seriessum-params = (ref / val) (ref / val) (ref / val) (ref / val)
0x019F
FACTDOUBLE
factdouble-params = (ref / val)
0x01A0
SQRTPI
sqrtpi-params = (ref / val)
0x01A1
QUOTIENT
quotient-params = (ref / val) (ref / val)
0x01A2
DELTA
delta-params = (ref / val) [ref / val]
0x01A3
GESTEP
gestep-params = (ref / val) [ref / val]
0x01A4
ISEVEN
iseven-params = (ref / val)
0x01A5
ISODD
isodd-params = (ref / val)
0x01A6
MROUND
mround-params = (ref / val) (ref / val)
0x01A7
ERF
erf-params = (ref / val) [ref / val]
0x01A8
ERFC
erfc-params = (ref / val)
0x01A9
BESSELJ
besselj-params = (ref / val) (ref / val)
0x01AA
BESSELK
besselk-params = (ref / val) (ref / val)
0x01AB
BESSELY
bessely-params = (ref / val) (ref / val)
0x01AC
BESSELI
besseli-params = (ref / val) (ref / val)
0x01AD
XIRR
xirr-params = (ref / val) (ref / val) [ref / val]
0x01AE
XNPV
xnpv-params = (ref / val) (ref / val) (ref / val)
0x01AF
PRICEMAT
pricemat-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01B0
YIELDMAT
yieldmat-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01B1
INTRATE
intrate-params = (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01B2
RECEIVED
received-params = (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01B3
DISC
disc-params = (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01B4
PRICEDISC
pricedisc-params = (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01B5
YIELDDISC
yielddisc-params = (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01B6
TBILLEQ
tbilleq-params = (ref / val) (ref / val) (ref / val)
0x01B7
TBILLPRICE
tbillprice-params = (ref / val) (ref / val) (ref / val)
0x01B8
TBILLYIELD
tbillyield-params = (ref / val) (ref / val) (ref / val)
0x01B9
PRICE
price-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01BA
YIELD
yield-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01BB
DOLLARDE
dollarde-params = (ref / val) (ref / val)
0x01BC
DOLLARFR
dollarfr-params = (ref / val) (ref / val)
0x01BD
NOMINAL
nominal-params = (ref / val) (ref / val)
0x01BE
EFFECT
effect-params = (ref / val) (ref / val)
0x01BF
CUMPRINC
cumprinc-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val)
0x01C0
CUMIPMT
cumipmt-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val)
0x01C1
EDATE
edate-params = (ref / val) (ref / val)
0x01C2
EOMONTH
eomonth-params = (ref / val) (ref / val)
0x01C3
YEARFRAC
yearfrac-params = (ref / val) (ref / val) [ref / val]
0x01C4
COUPDAYBS
coupdaybs-params = (ref / val) (ref / val) (ref / val) [ref / val]
0x01C5
COUPDAYS
coupdays-params = (ref / val) (ref / val) (ref / val) [ref / val]
0x01C6
COUPDAYSNC
coupdaysnc-params = (ref / val) (ref / val) (ref / val) [ref / val]
0x01C7
COUPNCD
coupncd-params = (ref / val) (ref / val) (ref / val) [ref / val]
0x01C8
COUPNUM
coupnum-params = (ref / val) (ref / val) (ref / val) [ref / val]
0x01C9
COUPPCD
couppcd-params = (ref / val) (ref / val) (ref / val) [ref / val]
0x01CA
DURATION
duration-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01CB
MDURATION
mduration-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01CC
ODDLPRICE
oddlprice-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01CD
ODDLYIELD
oddlyield-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01CE
ODDFPRICE
oddfprice-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01CF
ODDFYIELD
oddfyield-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01D0
RANDBETWEEN
randbetween-params = (ref / val) (ref / val)
0x01D1
WEEKNUM
weeknum-params = (ref / val) [ref / val]
0x01D2
AMORDEGRC
amordegrc-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01D3
AMORLINC
amorlinc-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01D5
ACCRINT
accrint-params = (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) (ref / val) *2(ref / val)
0x01D6
ACCRINTM
accrintm-params = (ref / val) (ref / val) (ref / val) (ref / val) [ref / val]
0x01D7
WORKDAY
workday-params = (ref / val) (ref / val) [ref / val]
0x01D8
NETWORKDAYS
networkdays-params = (ref / val) (ref / val) [ref / val]
0x01D9
GCD
gcd-params = (ref / val) *254(ref / val)
0x01DA
MULTINOMIAL
multinomial-params = (ref / val) *254(ref / val)
0x01DB
LCM
lcm-params = (ref / val) *254(ref / val)
0x01DC
FVSCHEDULE
fvschedule-params = (ref / val) (ref / val)
0x01DD
CUBEKPIMEMBER
cubekpimember-params = val val val [val]
0x01DE
CUBESET
cubeset-params = val (ref / val) [val [val [val]]]
0x01DF
CUBESETCOUNT
cubesetcount-params = val
0x01E0
IFERROR
iferror-params = val (ref / val)
0x01E1
COUNTIFS
countifs-params = ref val *126(ref val)
0x01E2
SUMIFS
sumifs-params = ref ref val *126(ref val)
0x01E3
AVERAGEIF
averageif-params = ref val [ref]
0x01E4
AVERAGEIFS
averageifs-params = ref ref val *126(ref val)
-
The following table specifies the names of future functions.
-
Future Function Value
Meaning
Parameters
_xlfn._xlws.FILTER
FILTER
filter-worksheet-params = 2*3(val)
If a formula (section 2.2.2) containing this structure is contained by a CellParsedFormula (section 2.5.98.4) that is contained by a Macro Sheet part (section 2.1.7.32) then filter-worksheet-params MUST NOT be used.
_xlfn._xlws.PY
PY
py-params = py-first-parameter py-second-parameter *252(val)
py-first-parameter-num = ptgNum
py-first-parameter-int = ptgInt
py-first-parameter = py-first-parameter-num / py-first-parameter-int
py-second-parameter = ptgInt
The Xnum (section 2.5.172) of the value field of the PtgNum (section 2.5.98.63) in the py-first-parameter-num rule MUST be 0-based index referencing CT_PythonScript element ([MS-XLSX] section 2.6.243) that indicates Python script corresponding to the function as specified in [MS-XLSX] section 2.3.10.1.
The integer field of the PtgInt (section 2.5.98.49 ) in the py-first-parameter-int rule MUST be 0-based index referencing CT_PythonScript element([MS-XLSX] section 2.6.243) that indicates Python script corresponding to the function as specified in [MS-XLSX] section 2.3.10.1.
The integer field of the ptgInt (section 2.5.98.49 ) in the py-second-parameter rule MUST be '0' or '1'.
If a formula (section 2.2.2) containing this structure is contained by a CellParsedFormula (section 2.5.98.4) that is contained by a Macro Sheet part (section 2.1.7.32) then py-params MUST NOT be used.
_xlfn._xlws.SORT
SORT
sort-worksheet-params = 1*4(val)
If a formula (section 2.2.2) containing this structure is contained by a CellParsedFormula (section 2.5.98.4) that is contained by a Macro Sheet part (section 2.1.7.32) then sort-worksheet-params MUST NOT be used.
_xlfn.ACOT
ACOT
acot-params = val
_xlfn.ACOTH
ACOTH
acoth-params = val
_xlfn.AGGREGATE
AGGREGATE
aggregate-params = 2(val) 1*2(ref / val) *250(ref)
_xlfn.ARABIC
ARABIC
arabic-params = val
_xlfn.BASE
BASE
base-params = val val [val]
_xlfn.BETA.DIST
BETA.DIST
betadist-params = val val val val *2(val)
_xlfn.BETA.INV
BETA.INV
beta-inv-params = val val val *2(val)
_xlfn.BINOM.DIST
BINOM.DIST
binom-dist-params = val val val val
_xlfn.BINOM.DIST.RANGE
BINOM.DIST.RANGE
binom-dist-range-params = val val val [val
_xlfn.BINOM.INV
BINOM.INV
binom-inv-params = val val val
_xlfn.BITAND
BITAND
bitand-params = val val
_xlfn.BITLSHIFT
BITLSHIFT
bitlshift-params = val val
_xlfn.BITOR
BITOR
bitor-params = val val
_xlfn.BITRSHIFT
BITRSHIFT
bitrshift-params = val val
_xlfn.BITXOR
BITXOR
bitxor-params = val val
_xlfn.BYCOL
BYCOL
bycol-params = 1*2(ref / val)
_xlfn.BYROW
BYROW
byrow-params = 1*2(ref / val)
_xlfn.CEILING.MATH
CEILING.MATH
ceiling-math-params = val [val [val]]
_xlfn.CEILING.PRECISE
CEILING.PRECISE
ceiling-precise-params = val val
_xlfn.CHISQ.DIST
CHISQ.DIST
chisq-dist-params = val val val
_xlfn.CHISQ.DIST.RT
CHISQ.DIST.RT
chisq-dist-rt-params = val val
_xlfn.CHISQ.INV
CHISQ.INV
chisq-inv-params = val val
_xlfn.CHISQ.INV.RT
CHISQ.INV.RT
chisq-inv-rt-params = val val
_xlfn.CHISQ.TEST
CHISQ.TEST
chisq-test-params = val val
_xlfn.CHOOSECOLS
CHOOSECOLS
choosecols-params = 2*254(val)
_xlfn.CHOOSEROWS
CHOOSEROWS
chooserows-params = 2*254(val)
_xlfn.COMBINA
COMBINA
combina-params = val val
_xlfn.CONCAT
CONCAT
concat-params = (ref / val) *253(ref / val)
_xlfn.CONFIDENCE.NORM
CONFIDENCE.NORM
confidence-norm-params = val val val
_xlfn.CONFIDENCE.T
CONFIDENCE.T
confidence-t-params = val val val
_xlfn.COT
COT
cot-params = val
_xlfn.COTH
COTH
coth-params = val
_xlfn.COVARIANCE.P
COVARIANCE.P
covariance-p-params = val val
_xlfn.COVARIANCE.S
COVARIANCE.S
covariance-s-params = val val
_xlfn.CSC
CSC
csc-params = val
_xlfn.CSCH
CSCH
csch-params = val
_xlfn.DAYS
DAYS
days-params = val val
_xlfn.DECIMAL
DECIMAL
decimal-params = val val
_xlfn.DROP
DROP
drop-params = 2*3(val)
_xlfn.ECMA.CEILING
ECMA.CEILING
ecma-ceiling-params = val val
_xlfn.ERF.PRECISE
ERF.PRECISE
erf-precise-params = (ref / val)
_xlfn.ERFC.PRECISE
ERFC.PRECISE
erfc-precise-params = (ref / val)
_xlfn.EXPAND
EXPAND
expand-params = 2*4(val)
_xlfn.EXPON.DIST
EXPON.DIST
expon-dist-params = val val val
_xlfn.F.DIST
F.DIST
f-dist-params = val val val val
_xlfn.F.DIST.RT
F.DIST.RT
f-dist-rt-params = val val val
_xlfn.F.INV
F.INV
f-inv-params = val val val
_xlfn.F.INV.RT
F.INV.RT
f-inv-rt-params = val val val
_xlfn.FIELDVALUE
FIELDVALUE
fieldvalue-params = val val
_xlfn.FILTERXML
FILTERXML
filterxml-params = val val
_xlfn.FLOOR.MATH
FLOOR.MATH
floor-math-params = val [val [val]]
_xlfn.FLOOR.PRECISE
FLOOR.PRECISE
floor-precise-params = val val
_xlfn.FORMULATEXT
FORMULATEXT
formulatext-params = ref
_xlfn.GAMMA
GAMMA
gamma-params = val
_xlfn.GAMMA.DIST
GAMMA.DIST
gamma-dist-params = val val val val
_xlfn.GAMMA.INV
GAMMA.INV
gamma-inv-params = val val val
_xlfn.GAMMALN.PRECISE
GAMMALN.PRECISE
gammaln-precise-params = val
_xlfn.GAUSS
GAUSS
gauss-params = val
_xlfn.HSTACK
HSTACK
hstack-params = 1*254(val)
_xlfn.HYPGEOM.DIST
HYPGEOM.DIST
hypgeom-dist-params = val val val val val
_xlfn.IFNA
IFNA
ifna-params = val (ref / val)
_xlfn.IFS
IFS
ifs-params = val (ref / val) *126(val (ref / val))
_xlfn.IMCOSH
IMCOSH
imcosh-params = val
_xlfn.IMCOT
IMCOT
imcot-params = val
_xlfn.IMCSC
IMCSC
imcsc-params = val
_xlfn.IMCSCH
IMCSCH
imcsch-params = val
_xlfn.IMSEC
IMSEC
imsec-params = val
_xlfn.IMSECH
IMSECH
imsech-params = val
_xlfn.IMSINH
IMSINH
imsinh-params = val
_xlfn.IMTAN
IMTAN
imtan-params = val
_xlfn.ISFORMULA
ISFORMULA
isformula-params = ref
_xlfn.ISO.CEILING
ISO.CEILING
iso-ceiling-params = val val
_xlfn.ISOMITTED
ISOMITTED
isomitted-params = (ref / val)
_xlfn.ISOWEEKNUM
ISOWEEKNUM
isoweeknum-params = val
_xlfn.LAMBDA
LAMBDA
lambda-params = 1*253(PtgName (ref / val)) (ref / val)
The PtgName (section 2.5.98.60) of the let-params rule MUST NOT be a VALUE_TYPE, as described in section 2.5.98.88. The string field of the XLNameWideString (section 2.5.166) of the name field of the BrtName (section 2.4.711) specified by the nameindex field of the PtgName (section 2.5.98.60) of the lambda-params rule MUST adhere to the following grammar (where name-start-character and name-character is specified in section 2.5.166):
string = ("_xlpm." / "_xlop.") parameter_name
parameter_name = name-start-character *name_character
parameter_name MUST NOT equal "TRUE" or "FALSE" (case-insensitive).
parameter_name MUST NOT be an A1 cell reference as specified in section 2.5.166.
_xlfn.LOGNORM.DIST
LOGNORM.DIST
lognorm-dist-params = val val val val
_xlfn.LOGNORM.INV
LOGNORM.INV
lognorm-inv-params = val val val
_xlfn.MAKEARRAY
MAKEARRAY
makearray-params = 3(ref / val)
_xlfn.MAP
MAP
map-params = 2*253(ref / val)
_xlfn.MAXIFS
MAXIFS
maxifs-params = ref ref val *125(ref val)
_xlfn.MINIFS
MINIFS
minifs-params = ref ref val *125(ref val)
_xlfn.MODE.MULT
MODE.MULT
mode-mult-params = 1*254(val)
_xlfn.MODE.SNGL
MODE.SNGL
mode-sngl-params = 1*254(val)
_xlfn.MUNIT
MUNIT
munit-params = val
_xlfn.NEGBINOM.DIST
NEGBINOM.DIST
negbinom-dist-params = val val val val
_xlfn.NETWORKDAYS.INTL
NETWORKDAYS.INTL
networkdays-intl-params = 2(ref / val) [val [ref / val]]
_xlfn.NORM.DIST
NORM.DIST
norm-dist-params = val val val val
_xlfn.NORM.INV
NORM.INV
norm-inv-params = val val val
_xlfn.NORM.S.DIST
NORM.S.DIST
norm-s-dist-params = val val
_xlfn.NORM.S.INV
NORM.S.INV
norm-s-inv-params = val
_xlfn.NUMBERVALUE
NUMBERVALUE
numbervalue-params = val [val [val]]
_xlfn.PDURATION
PDURATION
pduration-params = val val val
_xlfn.PERCENTILE.EXC
PERCENTILE.EXC
percentile-exc-params = (ref / val) val
_xlfn.PERCENTILE.INC
PERCENTILE.INC
percentile-inc-params = (ref / val) val
_xlfn.PERCENTRANK.EXC
PERCENTRANK.EXC
percentrank-exc-params = (ref / val) val [val]
_xlfn.PERCENTRANK.INC
PERCENTRANK.INC
percentrank-inc-params = (ref / val) val [val]
_xlfn.PERMUTATIONA
PERMUTATIONA
permutationa-params = val val
_xlfn.PHI
PHI
phi-params = val
_xlfn.POISSON.DIST
POISSON.DIST
poisson-dist-params = val val val
_xlfn.PQSOURCE
PQSOURCE
pqsource-params = *(PtgAttrSpace) PtgStr
PtgAttrSpace is specified in section 2.5.98.30.
cch field of the PtgStr (section 2.5.98.74) in the pqsource-params rule MUST be 36.
rgch field of the PtgStr (section 2.5.98.74) in the pqsource-params rule MUST match the guid rule of the following grammar:
decimal-digit = %x30-39
hex-digit = decimal-digit / %x41-46 / %x61-66
guid = 8hex-digit "-" 3(4hex-digit "-") 12hex-digit
_xlfn.PYTHON_STR
PYTHON_STR
python-str-params = val
_xlfn.PYTHON_TYPE
PYTHON_TYPE
python-type-params = val
_xlfn.PYTHON_TYPENAME
PYTHON_TYPENAME
python-typename-params = val
_xlfn.QUARTILE.EXC
QUARTILE.EXC
quartile-exc-params = (ref / val) val
_xlfn.QUARTILE.INC
QUARTILE.INC
quartile-inc-params = (ref / val) val
_xlfn.QUERYSTRING
QUERYSTRING
querystring-params = val val *126(val val)
_xlfn.RANDARRAY
RANDARRAY
randarray-params = *5(val)
_xlfn.RANK.AVG
RANK.AVG
rank-avg-params = val ref [val]
_xlfn.RANK.EQ
RANK.EQ
rank-eq-params = val ref [val]
_xlfn.RRI
RRI
rri-params = val val val
_xlfn.SEC
SEC
sec-params = val
_xlfn.SECH
SECH
sech-params = val
_xlfn.SEQUENCE
SEQUENCE
sequence-params = 1*4(val)
_xlfn.SHEET
SHEET
sheet-params = [(ref / val)]
_xlfn.SHEETS
SHEETS
sheets-params = [(ref / val)]
_xlfn.SKEW.P
SKEW.P
skew-p-params = (ref / val) *253(ref / val)
_xlfn.SORTBY
SORTBY
sortby-params = val val [val *125(val val)]
_xlfn.STDEV.P
STDEV.P
stdev-p-params = 1*254(ref / val)
_xlfn.STDEV.S
STDEV.S
stdev-s-params = 1*254(ref / val)
_xlfn.SWITCH
SWITCH
switch-params = val (ref / val) (ref / val) *251(ref / val)
_xlfn.T.DIST
T.DIST
t-dist-params = val val val
_xlfn.T.DIST.2T
T.DIST.2T
t-dist-twotails-params = val val
_xlfn.T.DIST.RT
T.DIST.RT
t-dist-rt-params = val val
_xlfn.T.INV
T.INV
t-inv-params = val val
_xlfn.T.INV.2T
T.INV.2T
t-inv-twotails-params = val val
_xlfn.T.TEST
T.TEST
t-test-params = val val val val
_xlfn.TAKE
TAKE
take-params = 2*3(val)
_xlfn.TEXTAFTER
TEXTAFTER
textafter-params = 2*6(val)
_xlfn.TEXTBEFORE
TEXTBEFORE
textbefore-params = 2*6(val)
_xlfn.TEXTJOIN
TEXTJOIN
textjoin-params = (ref / val) val (ref / val) *251(ref / val)
_xlfn.TEXTSPLIT
TEXTSPLIT
textsplit-params = 2*6(val)
_xlfn.TOCOL
TOCOL
tocol-params = 1*3(val)
_xlfn.TOROW
TOROW
torow-params = 1*3(val)
_xlfn.UNICHAR
UNICHAR
unichar-params = val
_xlfn.UNICODE
UNICODE
unicode-params = val
_xlfn.UNIQUE
UNIQUE
unique-params = 1*3(val)
_xlfn.VAR.P
VAR.P
var-p-params = 1*254(ref / val)
_xlfn.VAR.S
VAR.S
var-s-params = 1*254(ref / val)
_xlfn.VSTACK
VSTACK
vstack-params = 1*254(val)
_xlfn.WEBSERVICE
WEBSERVICE
webservice-params = val [val]
_xlfn.WEIBULL.DIST
WEIBULL.DIST
weibull-dist-params = val val val val
_xlfn.WORKDAY.INTL
WORKDAY.INTL
workday-intl-params = 2(ref / val) [val [ref / val]]
_xlfn.WRAPCOLS
WRAPCOLS
wrapcols-params = 2*3(val)
_xlfn.WRAPROWS
WRAPROWS
wraprows-params = 2*3(val)
_xlfn.XLOOKUP
XLOOKUP
xlookup-params = val (ref/val) (ref/val) [(ref/val) *2(val)]
_xlfn.XOR
XOR
xor-params = (ref / val) *253(ref / val)
_xlfn.Z.TEST
Z.TEST
z-test-params = (ref / val) val [val]
_xlfn.FORECAST.ETS
FORECAST.ETS
forecast-ets-params = val (ref / val) (ref / val) [val] [val] [val]
_xlfn.FORECAST.ETS.CONFINT
FORECAST.ETS.CONFINT
forecast-ets-confint-params = val (ref / val) (ref / val) [val] [val] [val] [val]
_xlfn.FORECAST.ETS.SEASONALITY
FORECAST.ETS.SEASONALITY
forecast-ets-seasonality-params = (ref / val) (ref / val) [val] [val]
_xlfn.FORECAST.ETS.STAT
FORECAST.ETS.STAT
forecast-ets-stat-params = val (ref / val) (ref / val) [val] [val] [val]
_xlfn.FORECAST.LINEAR
FORECAST.LINEAR
forecast-linear-params = val val val
_xlfn.LET
LET
let-params = 1*253(PtgName (ref / val)) (ref / val)
The PtgName (section 2.5.98.60) of the let-params rule MUST NOT be a VALUE_TYPE, as described in section 2.5.98.88.
The string field of the XLNameWideString (section 2.5.166) of the name field of the BrtName (section 2.4.711) specified by the nameindex field of the PtgName (section 2.5.98.60) of the let-params rule MUST adhere to the following grammar (where name_character is specified in section 2.5.166):
string = "_xlpm." parameter_name
parameter_name = name-start-character *name_character
parameter_name MUST NOT equal "TRUE" or "FALSE" (case-insensitive).
parameter_name MUST NOT be an A1 cell reference as specified in section 2.5.166.
-
-
The following grammar is used in the Rgce (section 2.5.98.88) structure definition.
-
sin-params / cos-params / tan-params / -
atan-params / sqrt-params / -
exp-params / ln-params / log10-params / -
abs-params / int-params / sign-params / -
round-params / rept-params / mid-params / -
len-params / value-params / not-params / mod-params / -
dcount-params / dsum-params / daverage-params / -
dmin-params / dmax-params / dstdev-params / -
dvar-params / text-params / goto-params / -
mirr-params / date-params / -
time-params / day-params / month-params / -
year-params / hour-params / minute-params / -
second-params / areas-params / -
rows-params / columns-params / absref-params / -
relref-params / transpose-params / -
type-params / deref-params / atan2-params / -
asin-params / acos-params / isref-params / -
get-formula-params / set-value-params / char-params / -
lower-params / upper-params / proper-params / -
exact-params / trim-params / replace-params / -
code-params / iserr-params / istext-params / -
isnumber-params / isblank-params / t-params / -
n-params / fclose-params / fsize-params / -
freadln-params / fread-params / fwriteln-params / -
fwrite-params / datevalue-params / timevalue-params / -
sln-params / syd-params / dialog-box-params / -
clean-params / mdeterm-params / minverse-params / -
mmult-params / while-params / initiate-params / request-params / -
poke-params / execute-params / terminate-params / -
fact-params / get-workspace-params / dproduct-params / -
isnontext-params / dstdevp-params / dvarp-params / -
islogical-params / dcounta-params / delete-bar-params / -
unregister-params / replaceb-params / midb-params / -
lenb-params / roundup-params / rounddown-params / -
asc-params / dbcs-params / else-if-params / -
sinh-params / cosh-params / tanh-params / -
asinh-params / acosh-params / atanh-params / -
dget-params / info-params / frequency-params / delete-toolbar-params / -
reset-toolbar-params / evaluate-params / error-type-params / -
enable-tool-params / press-tool-params / gammaln-params / -
binomdist-params / chidist-params / chiinv-params / -
combin-params / confidence-params / critbinom-params / -
even-params / expondist-params / fdist-params / -
finv-params / fisher-params / fisherinv-params / -
floor-params / gammadist-params / gammainv-params / -
ceiling-params / hypgeomdist-params / lognormdist-params / -
loginv-params / negbinomdist-params / normdist-params / -
normsdist-params / norminv-params / normsinv-params / -
standardize-params / odd-params / permut-params / -
poisson-params / tdist-params / weibull-params / -
sumxmy2-params / sumx2my2-params / sumx2py2-params / -
chitest-params / correl-params / covar-params / -
forecast-params / ftest-params / intercept-params / -
pearson-params / rsq-params / steyx-params / -
slope-params / ttest-params / large-params / -
small-params / quartile-params / percentile-params / -
trimmean-params / tinv-params / power-params / -
radians-params / degrees-params / countif-params / -
countblank-params / options-lists-get-params / ispmt-params / -
datedif-params / datestring-params / numberstring-params / -
phonetic-params / bahttext-params / thaidayofweek-params / -
thaidigit-params / thaimonthofyear-params / thainumsound-params / -
thainumstring-params / thaistringlength-params / isthaidigit-params / -
roundbahtdown-params / roundbahtup-params / thaiyear-params / -
cubememberproperty-params / hex2dec-params / oct2dec-params / -
bin2dec-params / imsub-params / imdiv-params / -
impower-params / imabs-params / imsqrt-params / -
imln-params / imlog2-params / imlog10-params / -
imsin-params / imcos-params / imexp-params / -
imargument-params / imconjugate-params / imaginary-params / -
imreal-params / seriessum-params / factdouble-params / -
sqrtpi-params / quotient-params / iseven-params / -
isodd-params / mround-params / erfc-params / -
besselj-params / besselk-params / bessely-params / -
besseli-params / xnpv-params / tbilleq-params / -
tbillprice-params / tbillyield-params / dollarde-params / -
dollarfr-params / nominal-params / effect-params / -
cumprinc-params / cumipmt-params / edate-params / -
eomonth-params / randbetween-params / convert-params / -
fvschedule-params / cubesetcount-params / iferror-params -
average-params / min-params / max-params / -
row-params / column-params / npv-params / -
stdev-params / dollar-params / fixed-params / -
lookup-params / index-params / and-params / -
or-params / var-params / linest-params / -
trend-params / logest-params / growth-params / -
halt-params / return-params / pv-params / -
fv-params / nper-params / pmt-params / -
rate-params / irr-params / match-params / -
weekday-params / offset-params / argument-params / -
search-params / error-params / echo-params / -
set-name-params / windows-params / -
documents-params / result-params / choose-params / -
hlookup-params / vlookup-params / links-params / -
input-params / get-name-params / log-params / -
exec-params / left-params / right-params / -
substitute-params / names-params / directory-params / -
find-params / cell-params / fopen-params / -
fpos-params / ddb-params / get-def-params / -
reftext-params / textref-params / indirect-params / -
register-params / call-params / add-bar-params / -
add-menu-params / add-command-params / enable-command-params / -
check-command-params / rename-command-params / show-bar-params / -
delete-menu-params / delete-command-params / get-chart-item-params / -
files-params / ipmt-params / ppmt-params / -
counta-params / cancel-key-params / for-params / -
restart-params / help-params / get-bar-params / -
product-params / get-cell-params / get-window-params / -
get-document-params / get-note-params / note-params / -
stdevp-params / varp-params / trunc-params / -
usdollar-params / findb-params / searchb-params / -
leftb-params / rightb-params / rank-params / -
address-params / days360-params / vdb-params / -
for-cell-params / median-params / sumproduct-params / -
create-object-params / volatile-params / custom-undo-params / -
custom-repeat-params / formula-convert-params / get-link-info-params / -
text-box-params / get-object-params / db-params / -
pause-params / resume-params / add-toolbar-params / -
user-defined-or-future-function / get-toolbar-params / get-tool-params / -
spelling-check-params / app-title-params / window-title-params / -
save-toolbar-params / register-id-params / get-workbook-params / -
avedev-params / betadist-params / betainv-params / -
prob-params / devsq-params / geomean-params / -
harmean-params / sumsq-params / kurt-params / -
skew-params / ztest-params / percentrank-params / -
mode-params / movie-command-params / get-movie-params / -
concatenate-params / pivot-add-data-params / get-pivot-table-params / -
get-pivot-field-params / get-pivot-item-params / subtotal-params / -
sumif-params / scenario-get-params / roman-params / -
open-dialog-params / save-dialog-params / view-get-params / -
getpivotdata-params / hyperlink-params / averagea-params / -
maxa-params / mina-params / stdevpa-params / -
varpa-params / stdeva-params / vara-params / -
rtd-params / cubevalue-params / cubemember-params / -
cuberankedmember-params / hex2bin-params / hex2oct-params / -
dec2bin-params / dec2hex-params / dec2oct-params / -
oct2bin-params / oct2hex-params / bin2oct-params / -
bin2hex-params / complex-params / imsum-params / -
improduct-params / delta-params / gestep-params / -
erf-params / xirr-params / pricemat-params / -
yieldmat-params / intrate-params / received-params / -
disc-params / pricedisc-params / yielddisc-params / -
price-params / yield-params / yearfrac-params / -
coupdaybs-params / coupdays-params / coupdaysnc-params / -
coupncd-params / coupnum-params / couppcd-params / -
duration-params / mduration-params / oddlprice-params / -
oddlyield-params / oddfprice-params / oddfyield-params / -
weeknum-params / amordegrc-params / amorlinc-params / -
accrint-params / accrintm-params / workday-params / -
networkdays-params / gcd-params / multinomial-params / -
lcm-params / cubekpimember-params / cubeset-params / -
countifs-params / sumifs-params / averageif-params / -
averageifs-params