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

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)



--
Regards,

Peo Sjoblom



"Deniz" wrote in message
...
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

Deniz,

=1 + RANDBETWEEN(10,25)/100

RANDBETWEEN only takes integers....

HTH,
Bernie
MS Excel MVP


"Deniz" wrote in message ...
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

Just modify it: =RANDBETWEEN(110,125)/100
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Deniz" wrote:
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