One way:

=100*(1+5%)^4

or

=100*1.05^4

In article ,
"Unionjack jackson" <Unionjack
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