View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
a0xbjzz a0xbjzz is offline
external usenet poster
 
Posts: 8
Default Using "=randbetween" to select a number from a range of cells

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?