poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Will Stranathan <w...@thestranathans.com>
Subject Re: Broken Formula
Date Thu, 06 Jan 2005 18:44:44 GMT
That's been posted - #32971 - thanks!

http://issues.apache.org/bugzilla/show_bug.cgi?id=32971

On Thu, 06 Jan 2005 13:39:39 -0500
  Danny Mui <danny@muibros.com> wrote:
>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/
>


---------------------------------------------------------------------
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/


Mime
View raw message