Hello, does anyone know how I increase the values in all of the cells in a column by a percentage ? I want to add 0.5% to each of the values in the cells. Many thanks in advance.
100% to stay where you started + 0.5% increase.
Example:
60 increased by 4% = 60 + 4% increase = 60 + 4%*60 = 60*(1 + 4%) = 60*(100% + 4%) = 60*(104%)
If cell B2 has your value you want to increase and cell C2 has the percentage (i.e., the number 0.005 with the cell formatted as a percentage so it displays as 0.5%, or you typed 0.5% into the cell which will do this) then in another cell use the formula
=B2*(1+C2)
Perfect! Thank you so much! Out of interest , why does one have to add '1' to the percentage? That's where I was going wrong!
Increasing values by a percentage
