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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
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/
---------------------------------------------------------------------
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/
