Exercise 19: A Custom Function

1. Create a UDF (User Defined Function)

To create this Function, execute the following steps

1. Open Excel VBA (Alt + F11)
2. Insert a New Module
3. In the Project Explorer, double click on the Module
4. Add the following code line:

This Code lines will create function Brickwall()

In Cell B1 Type

= Brickwall(A1)

Syntax

2. Use Excel Formulas (Bricks *2.25)