Increasing values by a percentage
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.
Question marked as
Best reply
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)