Generate Ranom Number

  • Thread starter Thread starter dipsy
  • Start date Start date
D

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.
 
Ranbetween generates integers between the two limits.
I would suggest you use "randbetween(2000,5000)/10000" or
whatever number of significant places you need.
 
Back
Top