Return-Path: Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org Received: (qmail 55857 invoked from network); 6 Jan 2005 18:33:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 6 Jan 2005 18:33:28 -0000 Received: (qmail 7076 invoked by uid 500); 6 Jan 2005 18:33:27 -0000 Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org Received: (qmail 6763 invoked by uid 500); 6 Jan 2005 18:33:26 -0000 Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "POI Users List" Reply-To: "POI Users List" Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 6750 invoked by uid 99); 6 Jan 2005 18:33:25 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from Unknown (HELO muibros.com) (69.28.209.52) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 06 Jan 2005 10:33:24 -0800 Received: from [127.0.0.1] ([::ffff:127.0.0.1]) by muibros.com with esmtp; Thu, 06 Jan 2005 13:34:35 -0500 Message-ID: <41DD85EB.5010704@muibros.com> Date: Thu, 06 Jan 2005 13:39:39 -0500 From: Danny Mui User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: POI Users List Subject: Re: Broken Formula References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Can you log this to bugzilla? thanks Will Stranathan wrote: > The doc says to "let us know" if you get any #VALUE! issues in setting > up a formula. I think I have one - I thought about sending to the > developer list, but hopefully some of the developers listen here... > > 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. > > Thanks, > Will Stranathan > > --------------------------------------------------------------------- > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/