Microsoft® Excel® 2010 Formulas & Functions Inside Out

Chapter 6. Custom Functions

• Creating a Custom Function

• The AreaCircle() Function

• The AreaQuad() Function

• The AreaSect() Function

• The DigitSum() Function

• The AreaCircle1() Function

• The Functions in the Function Wizard

• Saving Functions in Add-Ins

The numerous built-in math functions in Microsoft Excel allow you to perform complex calculations. But what happens if you cannot find the appropriate function or if you would rather use a simple syntax instead of a complicated formula? This chapter shows you the solution.

You could compare using Excel with driving a car. Until now you were comfortable sitting behind the wheel and using the built-in controls. Many controls were easily accessible on the dashboard, but others were hidden and could only be manipulated ...