Creating Formulas Using New Functions
The Microsoft Excel programming team encourages users to suggest new capabilities that could be included in future versions of the program. Apparently, one of the most common requests from corporations using Excel was to find the average value of cells in which the value met certain criteria. For example, in a table listing orders, a formula could find the average amount of all orders over $1,000.
Here are quick descriptions of the new functions and any existing functions to which theyâre related. The following figure shows these functions in action, and lists the exact formula used to calculate the cellâs values:
AVERAGEIF, which lets you find the average value of cells in a range for cells that meet a ...
Get Microsoft® Office Excel® 2007 Plain & Simple 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.
