I am trying to come up with a random number from a set of about 100 cells.
The only numbers available in those 100 cells are 0 thru 4.

HI. I think it depends on what you are doing. You didn't mention the
distribution of the numbers.
For example, if you only had 1-zero, 1-one, 1-two, 1-three, and 96 4's, then
using =RANDBETWEEN(0,4) would give equal weight to each number. Depending
on what you are doing, that may not be what you want.

Another option might be to give a percentage weight to the number of each
value. For example, if zero occured half the time, then using =RAND() might
be an option. If value if <=0.5, then pick 0, ...etc.

--
Dana DeLouis


"a0xbjzz" wrote in message
...
I've just begun using =randbetween, bear with me!

I am trying to come up with a random number from a set of about 100 cells.
The only numbers available in those 100 cells are 0 thru 4.

Do I set my function to choose a random number between 0 and 4
(=randbetween(0,4)) or do I set it to pick a random number from the range
of
cells (=randbetween(A1:A100))?

Is there going to be any difference in the data I come up with?