View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ahmad Ahmad is offline
external usenet poster
 
Posts: 23
Default eliminate negative value from normal random number distribution

hi
I try to generate normal distributed random number, my problem how i
can eliminate negative value, so i used this
function to generate random numbers
=(NORMSINV(RAND())*4)+6
where 4 is stdev, and 6 is average

thanks