K
ksnapp
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?
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?