excel 2010 statistical functions

[avi]

How do I use in VBA a 2010 worksheet function such as CHISQ.DIST?

Thanks
Avi

 

[isabelle]

hi Avi,

did you try
x = Evaluate("CHISQ.DIST( 3, 2, FALSE )")


http://www.excelfunctions.net/Excel-Chisq-Dist-Function.html


--
isabelle



Le 2012-01-19 16:46, avi a écrit :

 

[avi]

hi Avi,

did you try
x = Evaluate("CHISQ.DIST( 3, 2, FALSE )")

http://www.excelfunctions.net/Excel-Chisq-Dist-Function.html

Many thanks. Looks working well

Avi