Home |
Search |
Today's Posts |
#1
|
|||
|
|||
CHIINV error
Hi - According to Excel Help info, the CHIINV function should work for
degrees of freedom up to 10^10, but I get a #NUM error for any value greater than 1037. Example: CHIINV(0.95,1038) gives #NUM, as does any other value 1037. Can anyone help me with this? (Am I doing something wrong?, or is there a way to work around the problem?) Thank you. - Amy |
#2
|
|||
|
|||
Amy wrote... According to Excel Help info, the CHIINV function should work for degrees of freedom up to 10^10, but I get a #NUM error for any value greater than 1037. Example: CHIINV(0.95,1038) gives #NUM, as does any other value 1037. Can anyone help me with this? (Am I doing something wrong?, or is there a way to work around the problem?) The only thing you're doing wrong is believing Excel's online help contains no errors. There are lots of falsehoods therein, and Microsoft just can't seem to whip up the enthusiasm to correct them (some have been around for over a decade). For alternatives, see http://groups.google.com/groups?selm...0no_e-mail.com -- hgrove ------------------------------------------------------------------------ hgrove's Profile: http://www.excelforum.com/member.php...o&userid=11432 View this thread: http://www.excelforum.com/showthread...hreadid=274618 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Findlink Error | Links and Linking in Excel | |||
Illegal operation error while printing EXCEL or WORD Files | Excel Discussion (Misc queries) | |||
Error when entering and exiting excel | Excel Discussion (Misc queries) | |||
Downloading Templates for Excel error with a windows error. | Excel Discussion (Misc queries) | |||
#REF error | Excel Worksheet Functions |