ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   CHIINV error (https://www.excelbanter.com/excel-worksheet-functions/5541-chiinv-error.html)

Amy Bass

CHIINV error
 
Hi - According to the Excel Help info, the CHIINV function should work with
degrees of freedom up to 10^10, but I get a #NUM error whenever the value is
greater than 1037. Example: CHIINV(0.95,1038) gives a #NUM error, as does
any other degrees of freedom value of 1038 or more. Can anyone help me with
this? (Am I doing something wrong?, or Is there a way to work around this
problem?) Thank you - Amy


All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com