Percentage increase

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

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 jackson@discussions.microsoft.com> wrote in
message news:977AC678-E9DC-4444-9DCF-BBCF55353044@microsoft.com...
> 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

One way:

=100*(1+5%)^4

or

=100*1.05^4

In article <977AC678-E9DC-4444-9DCF-BBCF55353044@microsoft.com>,
"Unionjack jackson" <Unionjack jackson@discussions.microsoft.com>
wrote:

> 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