For 28 countries over a four-year period, I wish to determine the compound annual growth rate (CAGR).
I don't have all the information. The calculation will fail if there are any data gaps, so I must modify the formula to account for the number of years for which I have the data.

How can the calculation be changed automatically if a cell contains no data or if I discover missing data?
Nov 26, 2022 in Others 64 views

## 1 answer to this question.

Sep to calculate CAGR. Excel has an RRI function as mentioned in this article: https://www.excel-easy.com/examples/cagr.html

So the formula will be:

=RRI(No. of Years, Starting Amount, Ending Amount), This returns CAGR % over the years. very simple and beautiful. All other formulas are NOT intuitive for normal users.

• 51,600 points

## How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

## How to merge columns in Excel but keep data on other columns

VLOOKUP indeed can be used here, combined ...READ MORE

## In MS Excel what formula can be used to calculate growth when CAGR for the period is already given?

If those are true CAGR's, then just ...READ MORE

## In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS(\$H\$3:H3)<=\$I\$1,INDEX(Personnel! ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## Remove formulas from all worksheets in Excel using VBA

Try this : Option Explicit Sub test1() ...READ MORE

## Calculate monthly average from daily data without PivotTable

Assuming you have the months in column D enter ...READ MORE