=RANDBETWEEN and Decimals?

[Sub_Diver]

Need help with allowing three decimal places of random numbers generated between two numbers.

so Cell A1 would be 900.000 and Cell B1 would be 1000.000

I'm using:

=RANDBETWEEN(A1, B1)

I need it to give numbers with the decimal also random generated.

>>>What I'm getting 934.000, 978.000, 954.000, 976.000 - etc...

>>>What I'd like to get is 934.876, 978.993, 954.321, 976.107

Need a random 3 decimal places as well...

any ideas?

Thnx

 

[mdipalma]

jmiskey is correct. I did notice that, but thought it's very unlikely.

Even still, his method is better since it will avoid that possibility.

-Mike D

 

[Joe4]

Mike,

If your range is very far apart, i.e. 0-1000000, you are right, it is very unlikely. But if it is a small range, like 1-10, the odds get much higher, especially if you are doing a lot of calculations.

 

[mdipalma]

That's true. If it were something I were throwing together quickly for myself, I wouldn't have given it much thought. But in hindsight, without knowing more about what diver's situation is, I feel like I should have at least mentioned it when I broke out my solution, and let him decide if it was "close enough"

-Mike D

 

[dzinn478]

Sub_Diver

Be careful!

If it selects 1000 in the first part, your result will be over 1000. To see this, try this a few times, seeing that you will get a number greater than one:
=(RANDBETWEEN(0,1)+(ROUND((RAND()),3)))

To avoid going over 1.000 I used "=(RANDBETWEEN(0,0)+(ROUND((RAND()),3)))" and it seems to work.

inch	mm
0.282	7.16
0.409	10.39
0.006	0.15
0.274	6.96

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[hannah2233]

=(RANDBETWEEN(A1,B1)+(ROUND((RAND()),3))) does not work if the values of A1, B1 are <1.

Eg/ A=0.9 B=0.8
Randbetween with round to 1 then add the decimal so your value will be >1 which is not what you want