Trying to randomly choose a number from a set list of numbers
 

I'm trying to get Excel to randomly choose a number from a set of 58
different numbers using this formula:
=IF(AU2=1,CHOOSE(RANDBETWEEN(1,58),5,24,25,28,35,4 3,53,58,66,90,121,139,177,185,213,220,226,230,232, 233,256,265,288,290,297,304,
310,314,336,178,179,180,181,182,183,184,214,215,21 6,217,218,219,
337,354,364,369,379,383,398,404,421,423,442,446,45 9,463,467,484)))

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. If anyone knows how I can get this to work properly,
please let me know (on a side note, it will let me only choose from up to 29
values and no more than that for some reason).

Thanks,

RJ

Trying to randomly choose a number from a set list of numbers
 

The index within CHOOSE should be upto 29. Try with 29 numbers and it will
work.

If this post helps click Yes
---------------
Jacob Skaria


"RJTheDestroyer" wrote:

I'm trying to get Excel to randomly choose a number from a set of 58
different numbers using this formula:
=IF(AU2=1,CHOOSE(RANDBETWEEN(1,58),5,24,25,28,35,4 3,53,58,66,90,121,139,177,185,213,220,226,230,232, 233,256,265,288,290,297,304,
310,314,336,178,179,180,181,182,183,184,214,215,21 6,217,218,219,
337,354,364,369,379,383,398,404,421,423,442,446,45 9,463,467,484)))

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. If anyone knows how I can get this to work properly,
please let me know (on a side note, it will let me only choose from up to 29
values and no more than that for some reason).

Thanks,

RJ