Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default RAND()

pimpmyexcel

And you want to be taken seriously?

--
Biff
Microsoft Excel MVP


wrote in message
...
Charles!

Try out my excel addin function randStatic at :

www.pimpmyexcel.com

Look under statistical functions

Custom Excel Function: randStatic()

Category
Statistical Functions

Arguments
None

Returns
A mersenne twister generated random number in [0,1]
The function is non volatile, ie it only will not change on
recalculation

Examples
randStatic() returns a [0,1] random number only once





 
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
Rand between 1 and 50 Colin Excel Worksheet Functions 10 January 27th 09 09:23 PM
how can i set up rand or rand between to give only -1 or 1? Uesiet Excel Worksheet Functions 8 October 27th 08 02:28 PM
RAND() Dave F Excel Discussion (Misc queries) 4 October 24th 06 08:15 PM
help for RAND jinvictor Excel Worksheet Functions 3 May 13th 06 12:13 AM
RAND() ScottC Excel Discussion (Misc queries) 2 May 1st 05 12:37 PM


All times are GMT +1. The time now is 10:43 AM.

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"