Microsoft KB Archive/135642

= Works: CHOOSE Function Does Not Accept a Range Reference =

Article ID: 135642

Article Last Modified on 1/19/2007

-

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

-



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.