Thread: Random Numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Pivot Table[_2_] John Pivot Table[_2_] is offline
external usenet poster
 
Posts: 10
Default Random Numbers

Hey!

A question about random numbers in excel. I have a huge list of people and I
need to assign to each one a random number between 0.0 and 1.25.

The problem is I need the following:

70% of the people to be between 1 and 1.2
20% of the people to be above 1.2
10% of people below 1

any way I can do this randomly???

thanks!