Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 Bug!!!
Hello,
I have found a pretty big bug in excel 2003. I searched a little on Microsoft.com and couldn't find anything published about it but I did find a few things on the web about it. The rand() function gives bad numbers when a lot of them are used. I ran into this problem because I develope Financial software and we frequently use large amounts of random number to model things. If you have 2003 make a sheet with about 10000 calls to rand() and make them conditionally formatted that if they are not between 1 and 0 to display background color. Then hold down F9 key until they start showing up. It is pretty crazy. This is going to be a pretty big problem in excel, I know a lot of fields that use large amounts of random numbers to generate tests and models. And here I was pulling my hair out that I was programming a simple model wrong. :( Keith www.kjtfs.com --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible | Excel Worksheet Functions | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |