Brilliant! :)

Out of curiosity - how did you learn this solution?

"sebastienm" wrote:

Hi,
use the formula (replace each number by the cell address):
=10*(1+2%)^5

Regards,
Sebastien

"simsjr" wrote:

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?