Works: CHOOSE Function Does Not Accept a Range Reference

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q135642

Expand all | Collapse all

SUMMARY

The CHOOSE function in Microsoft Works Spreadsheet requires individual arguments. You cannot use the CHOOSE function to evaluate a range of cells.

The CHOOSE function uses the first argument in the function to select an appropriate value from the other arguments in the list.

Zero represents the first valid argument in the list.

Choose Function Examples:

CHOOSE(0,"Buy","Sell","Hold") would return "Buy" since zero corresponds to the first value in the list.

CHOOSE(A1,10,20,30) would return '10' if the value of cell A1 was zero, '20' if the value was 1, and '30' if the value was 2.

CHOOSE(A1,B2:F2) would return the value of ERR regardless of the value of cell A1, since the function does not accept range references.

APPLIES TO

Microsoft Works 6.0
Microsoft Works 2000 Standard Edition
Microsoft Works 3.0 Standard Edition
Microsoft Works 4.0 Standard Edition
Microsoft Works 4.5 Standard Edition

Back to the top

kbinfo kbui KB135642

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top