randbetween(1.1,1.25)

[Deniz]

Hi

I need to get random result between 1.1 and 1.25 like :
randbetween(1.1,1.25) or randbetween(1.125,1.235)

It gives always 1. How cani solve this ?

Thanks,

Deniz

 

[Peo Sjoblom]

It clearly states integers in the help, try something like this instead

=(RAND()*(1.25-1.1)+1.1

or


=ROUND(RAND()*(1.25-1.1)+1.1,2)

 

[Bernie Deitrick]

Deniz,

=1 + RANDBETWEEN(10,25)/100

RANDBETWEEN only takes integers....

HTH,
Bernie
MS Excel MVP

 

[Guest]

Just modify it: =RANDBETWEEN(110,125)/100