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 Deduct a Percentage in Excel. Spreadsheet programs like Microsoft Excel are powerful business tools. Managing a business comes down to numbers and data, and detailed, accurate records are ...

Excel's PERCENTOF function returns the percentage that a subset of data contributes to a whole dataset, saving you from having to create additional or complex formulas to generate the same outcome.