Comining lots of functions into one User defined function
 

Hello,

Im brand new to VBA, I've worked through all the examples I could
find.

Here is the deal. I have a series of functions that I nest to permorm
several calculactions. Entering this in as often as I need to is
tedious and trouble some. Copy and pasting isn't any better.
I would like to make my own function so all I have to do is give the
appropriate cell references and boom, I get the answer.

Here is the function as I use it now:
=ROUNDUP(((NORMSINV($B$7)*STDEV(IF($5:$5=b$5,7:7)) )+AVERAGE(IF($5:$5=C$5,7:7))),0)

Does any wanna take a stab and making that in VBA?

Please?


---
Message posted from http://www.ExcelForum.com/