# Creating list of random numbers based on values in other cells

1. ## Creating list of random numbers based on values in other cells

Hi guys,
I'm wasn't really sure how to describe what it is I'm trying to do in the title but i'll try explain it as best I can.

I'm basically wanting to create a list of random numbers using the rand() function, but the number of random numbers is dependent on the input value specified in a different cell. I realise theres probably an easy way to do it but I can't think of what to type in to search for it! Any help would be much appreciated!

2. ## Re: Creating list of random numbers based on values in other cells

the number of random numbers is dependent on the input value specified in a different cell

3. ## Re: Creating list of random numbers based on values in other cells

What does the input value have to do with the number of random values? Also, RAND() and RANDBETWEEN() both change values every time something is calculated on the workbook. If you want randomized numbers that don't change every time a calculation is ran, besides copy/pasting values, you'd probably want to look into VBA.

4. ## Re: Creating list of random numbers based on values in other cells

try:
=RAND()*(B1-A1)+A1
or
A random number greater than or equal to 0 but less than 100 (varies)
=RAND()*100

5. ## Re: Creating list of random numbers based on values in other cells

Hi Ross and welcome to the forum,

6. ## Re: Creating list of random numbers based on values in other cells

Hi Marvin,

That is exactly what I was looking for thanks so much! If you don't mind, could you explain what each step in the 'IF' function is doing?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1