This is what my Excel sheet looks like

I've been provided the \$ figure for the year 2020 in cell B5 and the CAGR % is reflected in cell L5.

The \$ figure for 2020 is 342.9 ( Cell B5) and the CAGR growth rate per year is 92.60% (Cell L5)

What formula can be used to calculate the \$ figure for the years 2021 through 2028?

Nov 20, 2022 in Others 449 views

## 1 answer to this question.

If those are true CAGR's, then just do =B5*(1+\$L5) and drag down and across.

I hope this helps you.
• 63,420 points

## What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

## How to format numbers as lakhs and crores in excel/ google spreadsheet when the number could be negative too?

Excel formatting, in my opinion, can only ...READ MORE

## Excel Formula which places date/time in cell when data is entered in another cell in the same row

Here's how to accomplish things in another ...READ MORE

## What is the character code for new line break in excel

Use CHAR(10) and Turn on Wrap Text option. It ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

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

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

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE