How to Calculate Profit Percentage in Excel (Formula & Examples)

Learn how to calculate profit percentage in Excel using simple formulas. Explore practical examples, step-by-step instructions, and profit calculation

 

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.

   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:

CellDescriptionAmount
A2Cost Price$800
B2Selling Price$1,000
C2Profit
D2Profit 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:

ProductCost PriceSelling PriceProfitProfit %
Headphones$500$700$20040%
Keyboard$800$1,000$20025%
Mouse$300$450$15050%
Monitor$5,000$5,750$75015%
Speaker$1,200$1,500$30025%

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:

  1. Enter all product names in column A.

  2. Enter the cost prices in column B.

  3. Enter the selling prices in column C.

  4. In cell D2, enter =C2-B2 to calculate profit.

  5. In cell E2, enter =IFERROR(D2/B2,0) to calculate profit percentage safely.

  6. Format column E as Percentage.

  7. 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

Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content