randbetween(1.1,1.25)
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
|