#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
  #2   Report Post  
Bob Umlas
 
Posts: n/a
Default

See http://support.microsoft.com/default...b;en-us;834520
Bob Umlas
Excel MVP

"JJ" wrote in message
...
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


  #3   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

Download current hotfixes. MS fixed this over a year ago.

Jerry

JJ wrote:

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.


Reply
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 09:23 PM
How do I auto number cells in an Excel template? Natalie Excel Discussion (Misc queries) 3 March 30th 05 04:42 AM
Number of dropdown fields in Excel is limited. I need more. How? UweVahrson Excel Discussion (Misc queries) 7 March 28th 05 06:10 PM
How do you create a random number generator in Excel? gmrobillard Excel Worksheet Functions 5 March 23rd 05 10: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 06:54 PM


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