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 [email protected]> wrote in
message news:[email protected]...
> 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 <[email protected]>,
"Unionjack jackson" <Unionjack [email protected]>
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