Profit Percentage Excel Formula: Easy Guide with Example

How to Calculate Profit Percentage in Excel with Simple Formulas

If you work with sales, business, or financial reports, knowing how to calculate profit percentage in Excel is essential. It helps track performance, evaluate pricing, and make better business decisions — all with a simple formula.

📌 What Is Profit Percentage?

Profit Percentage tells you how much profit you’ve made compared to your cost price. It’s a useful metric for analyzing profitability and margin in Excel spreadsheets.

The basic formula is:

Profit % = (Profit ÷ Cost Price) × 100

In Excel terms, this becomes:

=(Selling_Price - Cost_Price)/Cost_Price * 100

---

💡 Excel Formula Example

Imagine this setup in Excel:

A (Cost Price)	B (Selling Price)	C (Profit %)
100	150	=(B2-A2)/A2*100 → 50%
200	260	=(B3-A3)/A3*100 → 30%

Steps:

1. Enter your cost price in column A.
2. Enter your selling price in column B.
3. Use this formula in column C to calculate profit percentage:
   =(B2-A2)/A2*100
4. Drag the formula down to apply it to more rows.

---

✅ Tips for Accurate Results

• Format the result cell as Percentage (Home > Number > %).
• Use absolute cell references (like $A$2) if copying across sheets.
• Round off using: =ROUND((B2-A2)/A2*100, 2)

---

📊 Bonus: Add Conditional Formatting

Highlight profits above 50%:

1. Select the column with profit percentages.
2. Go to Home > Conditional Formatting > New Rule
3. Choose “Format cells that are greater than” → enter 50
4. Set a green fill to highlight high profits.

---

Conclusion

The profit percentage Excel formula is simple yet powerful. Whether you’re running a small business or analyzing large datasets, mastering this formula saves time and improves accuracy. Bookmark this guide for quick reference, and take your Excel skills to the next level.

Here is your Excel template that includes a profit percentage formula for each row: