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 and Me

Hey!

I´m having a little problem generating a few random numbers. The thing is
this: I have a huge list of people and I need to assign a random number
between 0.0 and 1.25 to each one.

The problem is I need the following:

70% of people to have a number between 1 and 1.2
20% of people to have a number greater than 1.2
10% of people to have a number below 1

Do you know how to do this???

Thanks!!