#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default CHIINV

I have been trying to use Excel's CHIINV worksheet
function in a visual basic application. Under certain
contains the function will fail to evaluate properly and
return #NUM instead of the appropriate value. Can
someone recommend while I can get some VB code that
emulates the CHIINV function?
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default CHIINV

I listed the wrong email address with the original post.
This is the correct address.


-----Original Message-----
I have been trying to use Excel's CHIINV worksheet
function in a visual basic application. Under certain
contains the function will fail to evaluate properly and
return #NUM instead of the appropriate value. Can
someone recommend while I can get some VB code that
emulates the CHIINV function?
.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 97
Default CHIINV

"Paul" wrote...
I have been trying to use Excel's CHIINV worksheet
function in a visual basic application. Under certain
contains the function will fail to evaluate properly and
return #NUM instead of the appropriate value. Can
someone recommend while I can get some VB code that
emulates the CHIINV function?


http://www.google.com/groups?selm=3F...0no_e-mail.com

--
To top-post is human, to bottom-post and snip is sublime.
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 837
Default CHIINV

Hi Harlan,

The Tecnometrics paper listed in that post is available online from the
University of Adelaide
http://www.library.adelaide.edu.au/d...fisher/281.pdf
as part of the Collected Papers of R.A. Fisher
http://www.library.adelaide.edu.au/d...her/index.html

Smith's library remains the most accurate double precision probability
library that I am aware of.

Jerry

Harlan Grove wrote:

"Paul" wrote...

I have been trying to use Excel's CHIINV worksheet
function in a visual basic application. Under certain
contains the function will fail to evaluate properly and
return #NUM instead of the appropriate value. Can
someone recommend while I can get some VB code that
emulates the CHIINV function?


http://www.google.com/groups?selm=3F...0no_e-mail.com


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default CHIINV

Thanks, this will take care of my problem.


-----Original Message-----
"Paul" wrote...
I have been trying to use Excel's CHIINV worksheet
function in a visual basic application. Under certain
contains the function will fail to evaluate properly

and
return #NUM instead of the appropriate value. Can
someone recommend while I can get some VB code that
emulates the CHIINV function?


http://www.google.com/groups?selm=3F176548.1010206%

40no_e-mail.com

--
To top-post is human, to bottom-post and snip is sublime.
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Apparent bug in CHIINV! Boris Excel Worksheet Functions 12 December 13th 10 09:52 PM
CHIINV error Amy Bass Excel Worksheet Functions 1 November 3rd 04 02:06 PM
CHIINV error Amy Excel Worksheet Functions 1 November 2nd 04 07:09 PM
CHIINV error Amy Bass Excel Worksheet Functions 0 November 2nd 04 06:30 PM
ChiInv function Stef C Excel Programming 5 November 22nd 03 06:59 PM


All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"