Excel provides the PRODUCT () function to calculate the original value by the percentage markup. Place your original value or cost into column A and label it with a description.

Input a formula in the final column to calculate the profit margin on the sale. The formula should divide the profit by the amount of the sale, or = (C2/A2)100 to produce a percentage.

Profit margin and markup are two accounting terms that use the same inputs and analyze the same transaction but they point to different information.