AdvSpreadGrid & FNCSpreadGrid CHOOSE function not working as documented

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.