This Excel tutorial explains how to use the Excel CHOOSE function with syntax and examples. The Microsoft Excel CHOOSE function returns a value from a list of values based on a given position.
CHOOSE全部显示全部隐藏 可以使用 index_num 返回数值参数列表中的数值。使用函数 CHOOSE 可以基于索引号返回多达 29 个基于 index number 待选数值中的任一数值。例如，如果数值 1 到 7 表示一个星期的 7 天，当用 1 到 7 之间的数字作 index_num 时，函数 CHOOSE 返回其中的某一天。语法CHOOSE(...
The function syntax ([ISO/IEC29500-1:2016] section 18.17.2.4) is extended by changing the function-name rule to: function-name = prefixed-function-name | predefined-function-name | user-defined-function-name | future-function-list | worksheet-only-function-list; The future-function-list and...
The value of thefCeFuncfield of the PtgFuncVar MUST be zero. The value of thetabfield of the PtgFuncVar MUST be 0x0064, which represents the CHOOSE function. val= expression Additional restrictions are specified under VALUE_TYPE. The params-fixed, params-variable and params-cetab rules also...
function-call = "CHOOSE" choose-params / "IF" if-params / "IF" if-worksheet-params / "INDEX" index-params / "INDIRECT" indirect-params / "OFFSET" offset-params future-function-call = ("_xlfn." ( ("ACOT" acot-params) / ("ACOTH" acoth-params) / ("AGGREGATE" aggregate-params) /...
The value of the tab field of the PtgFuncVar MUST be 0x0064, which represents the CHOOSE function. val = expression Additional restrictions are specified under VALUE_TYPE. The params-fixed, params-variable and params-cetab rules also use val. ref = expression Additional restrictions are ...
The value of thefCeFuncfield of thePtgFuncVarMUST be 0. The value of thetabfield of thePtgFuncVarMUST be 0x0064, which represents the CHOOSE function. val= expression Additional restrictions are specified under VALUE_TYPE. Theparams-fixed,params-variable(section 2.5.98.10), andparams-cetab(...
function-call = "CHOOSE" choose-params / "IF" if-params / "IF" if-worksheet-params / "INDEX" index-params / "INDIRECT" indirect-params / "OFFSET" offset-params future-function-call = ("_xlfn." ( ("ACOT" acot-params) / ("ACOTH" acoth-params) / ("AGGREGATE" aggregate-params) /...
This Excel tutorial explains how to use the Excel IF function with syntax and examples. The Microsoft Excel IF function returns one value if the condition is TRUE, or another value if the condition is FALSE.
Microsoft Office 2021 is a suite of productivity software that includes applications such as Word, Excel, PowerPoint, Outlook, OneNote, and more. It allows users to create, edit, share, and collaborate on various types of documents, spreadsheets, presentations, emails, notes, and other files. ...