Microsoft® Excel® 2010 Formulas & Functions Inside Out

The AreaQuad() Function

The AreaQuad(Length1,Length2,Height) function calculates the area of a quadrilateral with at least two parallel sides (square, rectangle, parallelogram, or trapezoid). This example will not only simplify the use of geometry formulas but also introduce some new methods.

This function shows you how to handle the following in custom functions:

• Several arguments

• Optional arguments

• Logical conditions

Functions with Several Arguments

Although many functions need only one argument (such as the trigonometry functions and the AreaCircle() function from the previous example), there are also many functions that use two or more arguments to calculate the return value. To calculate the area of a trapezoid, three values have to be passed as ...