ChiInv function
I have already done this kind of test, I use an excel
Sheet, put number 1 to 3500 in the "A" column, and get
the ChiInv solution on each values from 1 to 3500
(probability = 0.05) in the column "B", I get error on
value 818 but not 817 nor 819, it also bug on 928 to 948
values... there must be a logic behind that but cannot
catch it...
-----Original Message-----
Test your values in a worksheet using the formula in the
worksheet (not in
VBA).
If you get a #Value or #Ref or something like that,
check the Excel VBA help
and see what conditions cause that error to be displayed.
When you use WorksheetFunction.ChiInv, then a condition
that would return a
# type error in the worksheet raises a 1004 error in VBA.
Regards,
Tom Ogilvy
"Stef C" wrote in
message
...
Hi,
I am using the ChiInv function of Excel and get an
error
1004 when sending some values, but no error sending
other
values... it do not seem to be an error from a certain
value (ex: start bugging when sending a value of 512 or
more...) it seem to be random, but I know that it is
not... anybody know this one.
.
|