CODEWITHSUNDEEP
excelexcel-formula
Samantha
Samantha

Reputation: 75

How to calculate population in Excel if we only know the population growth rates and the starting population?

Given this information: The population in 2006 was 20,000,000.

and this information:

in 2007: the growth rate was 2.492035
in 2008: the growth rate was 1.733324
in 2009: it was 0.3956944

How can I create a function, which gives me the exact population numbers for 2007, 2008 and 2009?

I have tried some functions but they gave me false numbers.

Upvotes: 0

Views: 426

Answers (1)

player0
player0

Reputation: 1

well, it's either column C or column D

0

here is the sheet: https://docs.google.com/spreadsheets/

formula is: (2006population * 2007rate) + 2006population = 2007population

Upvotes: 1

Related Questions