xlsfunctionnames.inc

来自「delphi 第三方控件很出色,表格制作的」· INC 代码 · 共 389 行 · 第 1/4 页

INC
389
字号
  (Index:  288 ; Name: 'CEILING'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  289 ; Name: 'HYPGEOMDIST'; ArgCount:  4 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  290 ; Name: 'LOGNORMDIST'; ArgCount:  3 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  291 ; Name: 'LOGINV'; ArgCount:  3 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  292 ; Name: 'NEGBINOMDIST'; ArgCount:  3 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  293 ; Name: 'NORMDIST'; ArgCount:  4 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  294 ; Name: 'NORMSDIST'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  295 ; Name: 'NORMINV'; ArgCount:  3 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  296 ; Name: 'NORMSINV'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  297 ; Name: 'STANDARDIZE'; ArgCount:  3 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  298 ; Name: 'ODD'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  299 ; Name: 'PERMUT'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  300 ; Name: 'POISSON'; ArgCount:  3 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  301 ; Name: 'TDIST'; ArgCount:  3 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  302 ; Name: 'WEIBULL'; ArgCount:  4 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  303 ; Name: 'SUMXMY2'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  304 ; Name: 'SUMX2MY2'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  305 ; Name: 'SUMX2PY2'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  306 ; Name: 'CHITEST'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  307 ; Name: 'CORREL'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  308 ; Name: 'COVAR'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  309 ; Name: 'FORECAST'; ArgCount:  3 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  310 ; Name: 'FTEST'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  311 ; Name: 'INTERCEPT'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  312 ; Name: 'PEARSON'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  313 ; Name: 'RSQ'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  314 ; Name: 'STEYX'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  315 ; Name: 'SLOPE'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  316 ; Name: 'TTEST'; ArgCount:  4 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  317 ; Name: 'PROB'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  318 ; Name: 'DEVSQ'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  319 ; Name: 'GEOMEAN'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  320 ; Name: 'HARMEAN'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  321 ; Name: 'SUMSQ'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  322 ; Name: 'KURT'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  323 ; Name: 'SKEW'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  324 ; Name: 'ZTEST'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  325 ; Name: 'LARGE'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  326 ; Name: 'SMALL'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  327 ; Name: 'QUARTILE'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  328 ; Name: 'PERCENTILE'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  329 ; Name: 'PERCENTRANK'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  330 ; Name: 'MODE'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmArray; SwitchParamType: False),
  (Index:  331 ; Name: 'TRIMMEAN'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  332 ; Name: 'TINV'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  333 ; Name: ' 333 '; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  334 ; Name: 'MOVIE.COMMAND'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  335 ; Name: 'GET.MOVIE'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  336 ; Name: 'CONCATENATE'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  337 ; Name: 'POWER'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  338 ; Name: 'PIVOT.ADD.DATA'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  339 ; Name: 'GET.PIVOT.TABLE'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  340 ; Name: 'GET.PIVOT.FIELD'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  341 ; Name: 'GET.PIVOT.ITEM'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  342 ; Name: 'RADIANS'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  343 ; Name: 'DEGREES'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  344 ; Name: 'SUBTOTAL'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  345 ; Name: 'SUMIF'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  346 ; Name: 'COUNTIF'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  347 ; Name: 'COUNTBLANK'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  348 ; Name: 'SCENARIO.GET'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  349 ; Name: 'OPTIONS.LISTS.GET'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  350 ; Name: 'ISPMT'; ArgCount:  4 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  351 ; Name: 'DATEDIF'; ArgCount:  3 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  352 ; Name: 'DATESTRING'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  353 ; Name: 'NUMBERSTRING'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  354 ; Name: 'ROMAN'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  355 ; Name: 'OPEN.DIALOG'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  356 ; Name: 'SAVE.DIALOG'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  357 ; Name: 'VIEW.GET'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  358 ; Name: 'GETPIVOTDATA'; ArgCount:  0 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  359 ; Name: 'HYPERLINK'; ArgCount:  2 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  360 ; Name: 'PHONETIC'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  361 ; Name: 'AVERAGEA'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  362 ; Name: 'MAXA'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  363 ; Name: 'MINA'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  364 ; Name: 'STDEVPA'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  365 ; Name: 'VARPA'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  366 ; Name: 'STDEVA'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  367 ; Name: 'VARA'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmRef; SwitchParamType: False),
  (Index:  368 ; Name: 'BAHTTEXT'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  369 ; Name: 'THAIDAYOFWEEK'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  370 ; Name: 'THAIDIGIT'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  371 ; Name: 'THAIMONTHOFYEAR'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  372 ; Name: 'THAINUMSOUND'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  373 ; Name: 'THAINUMSTRING'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  374 ; Name: 'THAISTRINGLENGTH'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  375 ; Name: 'ISTHAIDIGIT'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  376 ; Name: 'ROUNDBAHTDOWN'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  377 ; Name: 'ROUNDBAHTUP'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  378 ; Name: 'THAIYEAR'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  379 ; Name: 'RTD'; ArgCount: -1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False),
  (Index:  380 ; Name: 'ISHYPERLINK'; ArgCount:  1 ; Volatile: false; ReturnType: fmValue; ParamType: fmValue; SwitchParamType: False)
);

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?