![\"percentage-to-total-excel-visual-basic-training\"](\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/percentage-to-total-excel-visual-basic-training.png\")
<\/a>NB This is useful if the % increase per month is the same. \u00a0If there are changes in % we need to add absolute references…but more on that in another post.<\/p>\n
In this example, I am looking at how to add a percentage increase to calculate a monthly projected fundraising target.<\/p>\n
Imagine my team is fundraising for a new community centre. In the last month they raised \u00a376,000. I’d like to increase the total per month, but not put them off, so I want to add 4.5% increase to each month. \u00a0So November’s target is 4.5% greater than October’s target, and December’s target is 4.5% greater than November’s figure.<\/p>\n
Excel can calculate this all for me. \u00a0So I set up a worksheet with the months of the year, and then a column for the current month’s fundraising target as our starting point. \u00a0The total is \u00a376,000 and I want the Target Fundraising column for November to show the total as \u00a376,000 plus the 4.5% included. So my formula is =B2*104.5%.<\/p>\n
(NB. If I used =B2*4.5% it would show the result as 4.5% of the total. \u00a0By adding 100 to the 4.5% the answer will show the sales target including the 4.5%).<\/p>\n
When I then copy the formula down the remainder of the column, the formula will take the total figure from the cell above it and apply 4.5%.<\/p>\n NB This is useful if the % increase per month is the same. \u00a0If there are changes in % we need to add absolute references…but more on that in another post.<\/p>\n<\/a>