To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115562 Issue #|115562 Summary|NORSMINV() Function not working properly (returning #V |ALUE!) Component|Spreadsheet Version|OOO320m18 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|bmaxim
------- Additional comments from [email protected] Sat Nov 13 16:48:11 +0000 2010 ------- I'm generating 10000 random numbers and calculates the normsinv() for each one. If you run this simulation (via F9) several times, you'll find that some times the formula returns a #VALUE! (since it's difficult to go over all the numbers, what I do is generate an AVG of the 10000 results). Something is wrong with the formula. I don't know the intrinsics to know how to fix it, but I'll be happy to help find the problem again. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
