Each item in the table has different price and cost, so the profit varies across items.
Profit margin is the ratio of profit divided by revenue.
As the formula is copied down, we get profit margin for each item in the table.
Note the result will be a decimal number like .10, .25, .30, etc.
To display this result as a percentage, applyPercentage number format.
you’re able to use theshortcutControl + Shift + %.
For example, 95% is read as “Ninety-five percent” and is equivalent to 95/100 or 0.95.
To display these numbers with a percent sign (%), applyPercentage number format.
