Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage function | Excel Worksheet Functions | |||
getting a percentage | Excel Worksheet Functions | |||
percentage of sales | Excel Worksheet Functions | |||
calculate percent increase | Excel Discussion (Misc queries) | |||
percentage of growth | Excel Worksheet Functions |