Creating Custom Functions to Use in Worksheets
Although Excel comes stocked with a wide variety of built-in functions, some of which are pretty specialized, they don't begin to cover all the types of specific computations you need to perform. Wouldn't it be great if you could extend the body of built-in Excel functions to include ones that your business uses? Well, you can do this, and this technique is dedicated to showing you how. Here, you find out how to turn your most precise and exacting calculations into functions available to any spreadsheet user through Excel's thoroughly familiar Insert Function feature.
All it takes for you to begin creating your own custom functions (known technically as user-defined functions or UDFs for short) is the briefest familarity with Excel's VBA (Visual Basic for Applications) language and Visual Basic Editor and the information you find in this technique.