Hi,

=10*(1.025^8)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"jenn" wrote in message
...
I have a dollar amount of $10 that gets 2.5 percent added to it each year.
How can I make the function to say ' in 8 years the amount will be ... '
if I
had 2.5% each year?

1 2 3 4 5 6 7 8
rate 2.80% 2.80% 2.80% 2.80% 2.80% 2.80% 2.80% 2.80%
$10.00 $10.28 $10.57 $10.86 $11.17 $11.48 $11.80 $12.13
$12.47