Exponential Growth
Hey,
Ok, so I have the value "10" in one cell (representing sales), and "5" in
another cell (representing number of days).
Now, I want to plug in, say, the value 2% in yet another cell and have excel
calculate the 2% as daily sales growth over the 5 days. Naturally, this means
sales will grow exponentially at a rate of 2% per day.
What I'd like to know is what function I would use to calculate this
exponential growth and return the total number of sales during the 5 days in
another cell.
Make sense?
|