Randbetween question

[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.

 

[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

 

[Leo Heuser]

Phil

One way:

Assuming random numbers between
123.78 and 156.97
use the formula

=RANDBETWEEN(12378,15697)/100

 

[Phil]

Thanks Bob and Leo .. Made my work more realistic .. Phil

 

[Leo Heuser]

You're welcome, Phil, and thanks
for the feedback

LeoH