O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required