Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i cant see my user defined functions in function list | Excel Worksheet Functions | |||
User defined functions without using VBA. | Excel Worksheet Functions | |||
About User Defined Functions | Excel Worksheet Functions | |||
User Defined Functions | Excel Worksheet Functions | |||
User Defined Functions | Excel Programming |