View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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