Thread: Results of my equation and function don't match

Please disregard. I mixed up my BSE2 and ASE2 when I went to use my function. Sometimes you get to staring at something for too long....

Originally Posted by danafer

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