LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JJ
 
Posts: n/a
Default Excel random number

Hi, I'm currently using Excel 2003 to do some actuarial work. I notice that
when I generate a large number of random numbers(say 10000) and run the
spreadsheet through Macro for a large number of times(say 1000), sometimes,
negative random number appears. My friends told me earlier versions didn't
have that problem. I'm sort of wondering what is going on with the random
generator of Excel 2003, and if Microsoft if going to develop a update to
solve this problem.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc
 
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
How do I start an Excel entry with then number 0? cajundoc Excel Discussion (Misc queries) 2 April 20th 05 08:23 PM
How do I auto number cells in an Excel template? Natalie Excel Discussion (Misc queries) 3 March 30th 05 03:42 AM
Number of dropdown fields in Excel is limited. I need more. How? UweVahrson Excel Discussion (Misc queries) 7 March 28th 05 05:10 PM
How do you create a random number generator in Excel? gmrobillard Excel Worksheet Functions 5 March 23rd 05 09:10 AM
Can the number of times undo is used in Excel 2002 be increased? Austrian Hannes Setting up and Configuration of Excel 2 December 6th 04 05:54 PM


All times are GMT +1. The time now is 10:06 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"