Excel Spreadsheet - Help

[JBW1366]

Hi, I am after some help for a spreadsheet - I have to calculated some figures and add on a percentage of interest on a monthly total - so column A figure Column B % -Column C new total - then next row again plus same percentage then the combined column C total etc etc - is there a simple sum?

Hope I have explained this correctly

[Old_Geezer]

Just multiply A by 1+B I'd have thought.

[JJ109]

If say the row is row 5

Formula for C5 would be =A5 +(B5*A5), then simply copy this formula for column c for all rows needed

[JJ109]

Old Geezer is correct also

[New Judge]

If the percentage is the same for every row you don't need to include it in the table at all. Example (for row 5 where the %age is 5%):

In A5, the amount.
In B5 =A5*1.05

Then replicate B5 down column B for as many rows as you want.

If you want the ability to vary the percentage, but apply it to every row, simply insert it at the top of the spreadsheet (say in cell A1). Then is (say) row 5:

In A5 the amount
In B5 = A5*$A$1
Then replicate B5 down column B

This will increase all the values you enter in column A by the percentage you enter in cell A1. If you want to change the percentage, simply change it in cell A1.

[JBW1366]

Thanks - speedy as always