Randbetween

[tlindeman]

I know how to use Randbetween, however is there any way to generate a random number between using a dataset? My low is 9.41 and my high is 19.68 and Randbetween only generates integers (whole numbers) I am open to VBA if someone can provide the code.

Thank You
Tony

 

[njimack]

=randbetween(941,1968)/100

 

[Scott Huish]

Yes, don't use RANDBETWEEN:

Excel Workbook
	A	B	C
1	Low	High	Random #
2	9.41	19.68	12.9009
Sheet1

 

[doublej_jj]

I like HotPepper's solution, but I don't think the '+1' is necessary. If you look at the two extreme cases where Rand() generates a 0 or 1, the the results should be the ends of the range. Therefore, just modify to

(B2-A2)*Rand()+A2

 

[tlindeman]

THank YOu, good suggestions

 

[Scott Huish]

Rand will never generate a 1 on its own.

It returns an evenly distributed random real number greater than or equal to 0 and less than 1

 

[doublej_jj]

HotPepper - You are definitely correct that it will not generate a 1. However, the '+1' still isn't needed as illustrated:

=(19.68 - 9.41 +1) * Rand() + 9.41

Rand() Answer
0 9.41
.25 12.22
.50 15.05
.75 17.86
.95 20.12

In this scenario, any number generated by Rand() that is greater than .911 will give an answer outside the range, ie greater than 19.68.

 

[Scott Huish]

You're right, usually you use the +1, if it is used with INT to generate whole numbers in a range.

 

[doublej_jj]

Thanks for the acknowledgement, but you did all the work on the solution. It is much easier to heckle from the crowd than be on stage. Maybe we should just call it good teamwork!