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 ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.