Mailing-List: contact poi-dev-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <poi-dev@jakarta.apache.org>
Date: Thu, 6 Jan 2005 19:38:56 +0100
Message-Id: <200501061838.j06IcupD017875@ajax.apache.org>
From: bugzilla@apache.org
To: poi-dev@jakarta.apache.org
Subject: DO NOT REPLY [Bug 32971]  New:  -
    Complex Formula (NORMSINV) giving #VALUE!

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: poi-dev@jakarta.apache.org
        ReportedBy: will@thestranathans.com


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: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/