Custom function #VALUE error

** Originally posted within worksheet formulas subcategory, but I later discovered that most of the threads in that subcategory deal with built-in Excel formulas. I am therefore re-posting here.

Hello,
I'm fairly new to VBA programming, and very new to creating custom functions. The function I'm trying to create would apply the TDIST worksheet function to the result of a series of calculations. Four arguments would be needed to feed the series of calculations.

The code I have been using below results in the #VALUE! error.

As far as I can tell, the formulas for the interim calculations are correct, although there could very well be errors in my code that attempts to make those calculations.

Any help would be appreciated. Thanks in advance.

Please Login or Register  to view this content.

Hi,

Just replace

sediffs = Sqr(pbar * (1 - pbar)) * (1 / base1 + 1 / base2)

by

sediffs = ((pbar * (1 - pbar)) * (1 / base1 + 1 / base2))^(1/2)

HTH