ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel 2010 statistical functions (https://www.excelbanter.com/excel-programming/445278-excel-2010-statistical-functions.html)

avi

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

Thanks
Avi

isabelle

excel 2010 statistical functions
 
hi Avi,

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


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


--
isabelle



Le 2012-01-19 16:46, avi a écrit :
How do I use in VBA a 2010 worksheet function such as CHISQ.DIST?

Thanks
Avi


avi

excel 2010 statistical functions
 
On 20 jan, 01:12, isabelle wrote:
hi Avi,

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

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

--
isabelle

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







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


Thanks
Avi


Many thanks. Looks working well

Avi


All times are GMT +1. The time now is 08:35 AM.

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