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
Top-ranking 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)