View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default randbetween(1.1,1.25)

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