My reply was addressing the OP's question about using the CHOOSE function
and the number of arguments it takes.

but it says "More arguments have been specified for
this function than are allowed in the current file format."

I'm wondering why it'd say this since the CHOOSE
function can choose between 1 and 254 values.

The number of arguments is version dependent.

The total number of arguments for the *CHOOSE* function is 30 in Excel
versions prior to Excel 2007. The number of *value arguments* is 29.


--
Biff
Microsoft Excel MVP


"Harlan Grove" wrote in message
...
"T. Valko" wrote...
The number of arguments is version dependent. In Excel 2007 you can have
up
to 254 value arguments. In all other versions you're limited to 29 value
arguments.
...

30 arguments, e.g., Excel 2003 correctly returns 465 for

=SUM
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,2 0,21,22,23,24,25,26,27,28,29,30)