LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Random Number Generator

Iım aware of the function ³=RAND()², that produces the numbers between 0 and
1, but Iım just trying to create a cell formula that produces an evenly
distributed number between two arbitrary values ....

Assuming I need between 1 and 10 (i.e., 1,2,3,4,5,6,7,8,9 or 10), how would
I achieve this without getting a skewed result?

I was thinking of =TRUNC((RAND()*10+1),0) ? Now thatıs just for between 1
and 10

Is there a better way of doing this * help!

Brad.)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Random number Generator RayT New Users to Excel 14 January 15th 08 11:16 PM
Random number generator deelee Excel Worksheet Functions 3 October 12th 06 07:46 PM
random number generator Barb Excel Discussion (Misc queries) 2 September 22nd 06 11:12 PM
Random Number Generator Pascale Excel Worksheet Functions 3 July 9th 05 12:37 AM
random number generator Jose Luis Excel Discussion (Misc queries) 1 June 14th 05 09:41 PM


All times are GMT +1. The time now is 03:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright İ2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"