The AreaCircle1() Function
This function does basically the same thing that the AreaCircle() function described at the beginning of this chapter does, but the AreaCircle1() function will also show you how to use integrated worksheet functions.
The AreaCircle() function uses pi as a constant with the value 3.14159265358979 to calculate the area of a circle (by utilizing the maximum decimal places allowed in Excel). But you won’t always have pi with all decimal places handy, in which case you will have to use additional handbooks with tables of mathematical constants.
An experienced Excel user could argue that Excel includes a Pi() function that calculates the area of a circle with sufficient accuracy (and speed). The custom functions described in ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
