Generate Ranom Number

[dipsy]

I want to generate random number between 0.2 and 0.5. I
am using the formula:

=randbetween(.2,.5) - it generates - 1.

Any help will be greatly appreciated.

 

[Jason Morin]

=RAND()*(0.3)+0.2

HTH
Jason
Atlanta, GA

 

[bj]

Ranbetween generates integers between the two limits.
I would suggest you use "randbetween(2000,5000)/10000" or
whatever number of significant places you need.

 

[Max]

Maybe also try: =randbetween(2,5)/10