ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Trying to randomly choose a number from a set list of numbers (https://www.excelbanter.com/excel-worksheet-functions/228903-trying-randomly-choose-number-set-list-numbers.html)

RJTheDestroyer

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

RJTheDestroyer

Trying to randomly choose a number from a set list of numbers
 
Oops, sorry for the double thread creation...it wasn't loading up when I
submitted it, so I tried a second time and now there's 2 of them :(


All times are GMT +1. The time now is 04:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com