Build VBA function for portfolio standard deviation

[Burritoman]

Does anyone know how to build a VBA function for portfolio standard deviation expandable.
Economy Probability High tech return
(i) (Pi) (Ri)

Recession 10% -27%
Below
Average 20% -7%

Average 40% 15%

Above
Average 20% 30%

Boom 10% 45%

 

[offthelip]

Your question is not clear , there are a number of Standard deviation functions already present in every version of EXCEL. what are you trying to do?

 

[Burritoman]

I'm trying to build my own VBA function that only requires me to select the probability and values to compute standard deviation.

 

[offthelip]

Have you looked at the NORMINV function? I suspect that it will do what you want