danafer
03-17-2010, 07:35 AM
Greetings! I'm a newer VBA programmer, and don't understand why the results of my VBA function don't match the result the same equation in a cell. Any thoughts?
My equation: =(E8/((1/CD8)*(CI8-(D8^2)*CF8)^0.5))
My function, where:
B = CD8
P = D8
D = E8
BSE2 = CI8
ASE2 = CF8
Function Zscore (B, P, D, BSE2, ASE2)
Zscore = D / ((1 / B) * (BSE2 - (P ^ 2) * ASE2) ^ 0.5)
End Function
My equation: =(E8/((1/CD8)*(CI8-(D8^2)*CF8)^0.5))
My function, where:
B = CD8
P = D8
D = E8
BSE2 = CI8
ASE2 = CF8
Function Zscore (B, P, D, BSE2, ASE2)
Zscore = D / ((1 / B) * (BSE2 - (P ^ 2) * ASE2) ^ 0.5)
End Function