» Calculating Average Annual Growth
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: 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:
No comments have been submitted.
