Knowledge Base

Works: CHOOSE Function Does Not Accept a Range Reference

Article ID: 135642

Article Last Modified on 1/19/2007

APPLIES TO

This article was previously published under Q135642

SUMMARY

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

MORE INFORMATION

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.


Additional query words: 3.00 4.00 4.00a 4.50 w_works works2k works6 error ref formula

Keywords: kbinfo kbui KB135642


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.