Works: CHOOSE Function Does Not Accept a Range Reference (135642)


The information in this article applies to:

  • Microsoft Works 6
  • Microsoft Works 2000
  • Microsoft Works 3.0
  • Microsoft Works 4.0
  • Microsoft Works 4.5
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.

Modification Type:MajorLast Reviewed:11/24/2003
Keywords:kbinfo kbui KB135642
©2003 Microsoft Corporation. All rights reserved.