Learn how to calculate profit percentage in Excel with easy formulas and practical examples. Find profit, compare product profitability, and automate calculations for multiple products.
How to Calculate Profit Percentage in Excel (Formula & Examples)
Calculating profit percentage is one of the easiest ways to understand how much money you earn from a sale, product, or business transaction. Whether you run a small shop, sell products online, or manage business accounts, knowing your profit percentage helps you evaluate your performance and make better financial decisions.
Microsoft Excel makes this calculation simple. You don't need complicated accounting software or advanced mathematical knowledge. With a basic formula, you can calculate profit percentage in seconds and apply it to multiple products or transactions.
In this guide, you'll learn how to calculate profit percentage in Excel using simple formulas, practical examples, and an easy-to-follow table.
What Is Profit Percentage?
Profit percentage tells you how much profit you earn compared to the original cost of a product or service.
For example, suppose you purchase a product for $500 and sell it for $650. Your profit is $150.
However, knowing the profit amount alone doesn't tell you how profitable the sale was. Calculating the profit percentage gives you a clearer picture.
In this example:
Cost Price: $500
Selling Price: $650
Profit: $150
Profit Percentage: 30%
This means you earned a profit equal to 30% of your original investment.
Profit Percentage Formula in Excel
Before using Excel, it's helpful to understand the basic mathematical formula.
Profit Percentage = (Profit / Cost Price) × 100
Since profit is the difference between the selling price and the cost price, the formula can also be written as:
Profit Percentage = ((Selling Price - Cost Price) / Cost Price) × 100
You can use this formula directly in an Excel worksheet.
How to Calculate Profit Percentage in Excel
Let's understand the calculation with a simple example.
Suppose you purchased a product for $800 and sold it for $1,000. You want to calculate the profit percentage using Excel.
Follow these steps:
Step 1: Enter Your Data
Open Microsoft Excel and create a small table with the following columns:
| Cell | Description | Amount |
|---|---|---|
| A2 | Cost Price | $800 |
| B2 | Selling Price | $1,000 |
| C2 | Profit | |
| D2 | Profit Percentage |
Step 2: Calculate the Profit
Click cell C2 and enter this formula:
=B2-A2
Press Enter.
Excel will calculate the profit automatically.
The result will be $200.
Step 3: Calculate the Profit Percentage
Now click cell D2 and enter:
=(C2/A2)*100
Press Enter.
Your result will be 25.
This means your profit percentage is 25%.
Alternative formula: You can calculate the profit percentage directly without using a separate profit column.
=((B2-A2)/A2)*100
Both formulas produce the same result.
Step 4: Format the Result as a Percentage
You can also display the result with a percentage symbol instead of multiplying it by 100.
Use this formula:
=(B2-A2)/A2
Then select the result cell and click the Percentage (%) button in Excel's Home tab.
Your result will appear as 25%.
This is generally the recommended approach because Excel stores percentages as decimal values.
Practical Example of Profit Percentage in Excel
Let's look at another example involving multiple products.
Imagine you run an online store and want to calculate the profit percentage of different products.
Create the following table in Excel:
| Product | Cost Price | Selling Price | Profit | Profit % |
|---|---|---|---|---|
| Headphones | $500 | $700 | $200 | 40% |
| Keyboard | $800 | $1,000 | $200 | 25% |
| Mouse | $300 | $450 | $150 | 50% |
| Monitor | $5,000 | $5,750 | $750 | 15% |
| Speaker | $1,200 | $1,500 | $300 | 25% |
Assuming your data starts in row 2, enter the following formulas:
Profit Formula (D2):
=C2-B2
Profit Percentage Formula (E2):
=D2/B2
Format column E as Percentage.
Now drag both formulas down to calculate the profit and profit percentage for every product.
Excel will automatically adjust the cell references for each row.
This method is especially useful when managing product prices, comparing business performance, or preparing monthly sales reports.
How to Calculate Profit Percentage for Multiple Products Automatically
If you regularly work with hundreds of products, calculating profit percentage one product at a time can become time-consuming.
Fortunately, Excel allows you to automate the entire process.
Follow these steps:
Enter all product names in column A.
Enter the cost prices in column B.
Enter the selling prices in column C.
In cell D2, enter
=C2-B2to calculate profit.In cell E2, enter
=IFERROR(D2/B2,0)to calculate profit percentage safely.Format column E as Percentage.
Drag the formulas down to apply them to all products.
The IFERROR function prevents an error from appearing when the cost price is zero or the calculation cannot be completed.
Your worksheet will automatically calculate profit percentages whenever you update the cost or selling price.
Profit Percentage vs Profit Margin: What's the Difference?
Profit percentage and profit margin are often confused, but they are not the same.
The main difference is the value used as the denominator.
Profit Percentage: Calculates profit compared to the cost price.
Profit Margin: Calculates profit compared to the selling price.
Let's understand this with an example.
Suppose you purchase a product for $800 and sell it for $1,000.
Your profit is $200.
Profit Percentage:
=(200/800)*100
Result: 25%
Profit Margin:
=(200/1000)*100
Result: 20%
Both calculations are correct, but they answer different questions.
Profit percentage tells you how much you earned compared to your investment, while profit margin shows how much of your sales revenue remains as profit.
How to Calculate Loss Percentage in Excel
Sometimes, a product sells for less than its original cost. In this situation, you have a loss instead of a profit.
For example:
Cost Price: $1,000
Selling Price: $850
Loss: $150
The loss percentage formula is:
Loss Percentage = (Loss / Cost Price) × 100
In Excel, if the cost price is in B2 and the selling price is in C2, use:
=((B2-C2)/B2)*100
The result will be 15%.
This means you experienced a loss of 15% compared to the original cost.
If you want one formula that handles both profit and loss, use:
=IFERROR((C2-B2)/B2,0)
Format the result as Percentage.
A positive result indicates profit, a negative result indicates loss, and zero means you broke even.
Common Mistakes to Avoid When Calculating Profit Percentage
Even a simple Excel formula can produce misleading results if the wrong values are entered.
Here are some common mistakes to watch out for:
Using Selling Price Instead of Cost Price
Profit percentage is calculated using the cost price as the denominator. Using the selling price gives you profit margin instead.
Forgetting Percentage Formatting
If you use =D2/B2 and see 0.25, the formula is correct. Simply format the cell as Percentage to display 25%.
Dividing by Zero
If the cost price is zero, Excel cannot calculate a meaningful profit percentage. Use IFERROR to prevent formula errors.
Entering Incorrect Prices
Make sure your cost price and selling price are correct. Incorrect values will produce misleading results.
Ignoring Additional Expenses
If you want to calculate your actual business profit, remember to include additional costs such as packaging, delivery, platform fees, commissions, and other expenses.
For example, if you purchase a product for $500, spend another $50 on delivery and packaging, and sell it for $700, your actual profit is $150 rather than $200.
Frequently Asked Questions (FAQs)
1. What is the formula for profit percentage in Excel?
Use =(Selling Price-Cost Price)/Cost Price and format the result as Percentage.
2. How do I calculate 20% profit in Excel?
If your cost price is in A2, multiply it by 1.20 using =A2*1.20 to calculate the selling price needed for a 20% markup.
3. Can Excel calculate profit percentage automatically?
Yes. Enter the cost price and selling price, apply the profit percentage formula, and drag it down to calculate results for multiple products.
4. What is the difference between profit percentage and profit margin?
Profit percentage compares profit with cost price, while profit margin compares profit with selling price.
5. Can I calculate both profit and loss using one Excel formula?
Yes. Use =IFERROR((C2-B2)/B2,0) and format the result as Percentage. Positive values indicate profit, while negative values indicate loss.
Final Thoughts
Calculating profit percentage in Excel is a simple but valuable skill for anyone who manages sales, purchases, or business finances.
With the formula =(Selling Price-Cost Price)/Cost Price, you can quickly find out how much profit you earn compared to your original investment.
You can also use Excel to automate calculations for multiple products, compare profitability, identify better-performing items, and maintain accurate business records.
Whether you're a student, shop owner, freelancer, or business professional, learning this formula can make everyday financial calculations much easier.

COMMENTS