Randbetween question

P

Phil

Is it possible to generate numbers that have decimal
numbers? When I use RANDBETWEEN function I only seem to
get integers. It sure would be nice to gereate random
numbers that are between specific numbers that have
decimals.
 
B

Bob Umlas

Why not simply use RAND? To get numbers between 50 and 80, for example, you
can use
=30*RAND()+50 where the 30 is the difference and the 50 is the lowest #.
Bob Umlas, Excel MVP
 
L

Leo Heuser

Phil

One way:

Assuming random numbers between
123.78 and 156.97
use the formula

=RANDBETWEEN(12378,15697)/100
 
Top