Hi.
Doc: CHOOSE(sel;param1;param2)
: returns param1 if sel>0 else param2
Real world: returns param1 if sel=0 else param2
Even AdvSpreadGridDemo is based on this second description (see formulas in Main Demo tab, cells B20 & B21).
Hi.
Doc: CHOOSE(sel;param1;param2)
: returns param1 if sel>0 else param2
Real world: returns param1 if sel=0 else param2
Even AdvSpreadGridDemo is based on this second description (see formulas in Main Demo tab, cells B20 & B21).
Sorry, this was a typo in the doc. We updated it.
The correct definition is:
CHOOSE(sel;param1;param2) : returns param1 if sel=0 else param2
This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.