The formula tells Excel to compute percentage markup and place it in the Percent Markup column. Copy the formula by clicking the black square in the lower right corner of cell C2 dragging down.

How to Calculate Percentage Change. Calculating percentage change is one of the most frequently used tasks in Excel. The basic formula is: (New Value / Old Value) – 1.