Hi
The formula would be 100*1.05 to the power of the number of years you
require.
With £100 in A1, 5% in B1, 10 (or number of years) in C1 then in D1
=A1*(1+B1)^C1 will yield your result.
You can then alter the rate or number of years very easily by changing B1
and C1
--
Regards
Roger Govier
"Unionjack jackson" <Unionjack
wrote in
message ...
hi just wondering if someone could help?
example todays cost £100 + 5% = £105 + 5% = £110.25 + 5% = £115.76 + 5% =
121.55 and so on is there a formula for doing the above in one cell?
any help appeciated
Paul