View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default need help using "RANDBETWEEN" in excel

=RANDBETWEEN(135,165)/100


"glenn" wrote:

In using this function, I'm entering values as decimals (ie, I'm looking for
a random number between 1.35 and 1.65. When I do this I get a result of 2.
That's obviously not a number between 1.35 and 1.65. What am I doing wrong?