» Calculating Average Annual Growth
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Columns A & B show annual profits for a number of years.
We want to calculate the average rate at which profits grew each year.
Solution:
Use the AVERAGE function in the following Array formula:
{=AVERAGE((B3:B5-B2:B4)/B2:B4)}
Book Store:
Recommended Books:
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Microsoft Windows XP Inside Out
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Microsoft Word Version 2002 Inside Out
- Windows XP for Dummies
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
