DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG� RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=32971>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND� INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=32971 Summary: Complex Formula (NORMSINV) giving #VALUE! Product: POI Version: 2.0FINAL Platform: PC OS/Version: Linux Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: [email protected] ReportedBy: [EMAIL PROTECTED] The following formula: =IF(C2=B2,0,IF((C2=0),6,NORMSINV(1-(C2/B2))+1.5)) gives a #VALUE! in F2. B2 =16923 C2 =6039 D2 =(B2-C2)/B2 E2 =C2/B2*(10^6) // I had to do (10^6) - 1000000 complains 'Value out of range. Value:"1000000" Radix:10' F2 =IF(C2=B2,0,IF((C2=0),6,NORMSINV(1-(C2/B2))+1.5)) If I open the newly-created sheet, those cells show that value, but if I go through and hit F2 (edit) and just Enter in each of those types of fields, they get re-parsed and corrected. -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
