View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Using Excel defined functions in UDF

I'm trying to create a UDF that allows users to input to binomial
experiments and the results will be a p-value for comparing the
proportions.

My function crashes everytime I try to use an excel built in function
like

SQRT(X) or NORMSDIST(X)... etc

SQRT I got around by using (X) ^ 0.5 and I found a formula that got me
close the normdist, but I'd like to use the exact formula in excel

Thanks,
Matt