How to Calculate Loss in Excel (Formula & Examples)

Learn how to calculate loss in Excel using simple formulas. Find loss amounts, loss percentages, and automatic calculations with practical examples.
How to Calculate Loss in Excel (Formula & Examples)

   Learn how to calculate loss in Excel using easy formulas and practical examples. Discover how to calculate loss amounts, loss percentages, and automatically track business losses using Excel functions.

How to Calculate Loss in Excel (Formula & Practical Examples)

Calculating a loss is an important part of managing business expenses, tracking investments, checking sales performance, or understanding whether a transaction has made or lost money. If you use Microsoft Excel, you don't need to calculate everything manually. A simple subtraction formula can help you find your exact loss in seconds.

For example, suppose you purchased a product for $500 but sold it for $420. You have lost $80 on that transaction. Excel can calculate this automatically, and you can use the same method for multiple products, business transactions, or investment records.

In this guide, you'll learn how to calculate loss in Excel using simple formulas, practical examples, and percentage calculations. Whether you're a beginner or someone who regularly works with spreadsheets, these methods will make loss calculations easier.

What Is Loss in Excel?

A loss occurs when the selling price or final amount received is lower than the original purchase price or cost.

The basic formula is:

Loss = Cost Price - Selling Price

For example:

  • Cost Price: $1,000

  • Selling Price: $850

  • Loss: $150

This means you lost $150 because the selling price was lower than the purchase cost.

In Excel, you can calculate this difference using a simple subtraction formula.

Basic Formula to Calculate Loss in Excel

The easiest way to calculate loss in Excel is by subtracting the selling price from the cost price.

Excel Formula:

=A2-B2

Here:

  • A2 contains the Cost Price.

  • B2 contains the Selling Price.

The formula returns the loss amount when the cost price is greater than the selling price.

Example:

DescriptionAmount
Cost Price (A2)$1,500
Selling Price (B2)$1,200
Loss (C2)$300

Enter the following formula in cell C2:

=A2-B2

Excel will display $300 as the total loss.

If the selling price is higher than the cost price, the result will be negative, which indicates a profit rather than a loss.

How to Calculate Loss in Excel Step by Step

Follow these simple steps to calculate the loss on a product or transaction.

Step 1: Enter the Cost Price

Open a new Excel worksheet and enter the purchase cost in cell A2.

Step 2: Enter the Selling Price

Enter the amount you received from selling the product in cell B2.

Step 3: Apply the Loss Formula

Click cell C2 and type:

=A2-B2

Step 4: Press Enter

Press Enter on your keyboard. Excel will automatically calculate the difference between the cost price and selling price.

Step 5: Check the Result

If the result is positive, you have a loss. If it is negative, you have made a profit.

This method works for individual transactions and can also be applied to larger business records.

How to Calculate Loss Percentage in Excel

Sometimes, knowing the actual loss amount isn't enough. You may also want to understand how much you lost compared with your original investment or purchase cost.

For this, you can calculate the loss percentage.

Loss Percentage Formula:

=(Cost Price-Selling Price)/Cost Price*100

Suppose you purchased a laptop for $800 and sold it for $680.

Your loss is:

$800 - $680 = $120

Your loss percentage is:

($120 / $800) × 100 = 15%

Excel Formula:

If the cost price is in A2 and the selling price is in B2, enter:

=(A2-B2)/A2

Then select the result cell and click the Percentage (%) button under the Home tab.

Excel will display 15%.

This formula helps you compare losses across different products, transactions, or investments.

How to Calculate Loss Automatically for Multiple Products

If you manage a shop, business, or inventory, calculating losses one transaction at a time can become inconvenient. Excel allows you to calculate losses for multiple products using the same formula.

Consider the following example:

ProductCost PriceSelling PriceLoss
Laptop$800$700$100
Mobile$500$450$50
Monitor$300$250$50
Keyboard$100$80$20
Printer$400$350$50

Enter the following formula in cell D2:

=B2-C2

After pressing Enter, drag the fill handle down to apply the formula to the remaining rows.

Excel will automatically calculate the loss for every product.

This is especially useful for shop owners, retailers, wholesalers, and small business operators who regularly compare purchase and selling prices.

How to Calculate Only Loss in Excel Without Negative Values

The basic subtraction formula can return a negative number when the selling price is higher than the cost price.

If you want Excel to display only actual losses and show zero when there is a profit, use the IF function.

Excel Formula:

=IF(A2>B2,A2-B2,0)

Here:

  • A2 represents the Cost Price.

  • B2 represents the Selling Price.

  • If the cost price is higher, Excel calculates the loss.

  • If the selling price is higher or equal, Excel displays zero.

Example:

Cost PriceSelling PriceLoss
$1,000$800$200
$500$600$0
$750$750$0
$900$700$200

This formula is helpful when preparing business reports where you want to separate losses from profitable transactions.

How to Calculate Loss Percentage Automatically in Excel

You can also calculate the loss percentage for multiple products without entering the formula repeatedly.

Suppose your worksheet contains the following columns:

ProductCost PriceSelling PriceLossLoss %
Laptop$1,000$900$10010%
Mobile$800$680$12015%
Monitor$500$450$5010%

Use this formula in cell D2 to calculate the loss:

=MAX(B2-C2,0)

Next, enter this formula in cell E2:

=IF(B2>0,D2/B2,0)

Format column E as Percentage.

Drag both formulas down to calculate the loss amount and percentage for all products.

The MAX function prevents negative loss amounts, while the IF function avoids a division-by-zero error when the cost price is zero.

Difference Between Loss Amount and Loss Percentage

Both calculations help you understand financial performance, but they provide different information.

ComparisonLoss AmountLoss Percentage
MeaningActual money lostLoss compared with cost
FormulaCost Price - Selling Price(Loss / Cost Price) × 100
Example$10010%
Best ForTracking money lostComparing performance
Result FormatCurrencyPercentage

For example, losing $100 on a product purchased for $1,000 represents a 10% loss. However, losing the same $100 on a product purchased for $200 represents a 50% loss.

This is why checking both values gives you a clearer picture of your financial performance.

Common Mistakes to Avoid When Calculating Loss in Excel

Even simple Excel formulas can produce incorrect results if the data is entered incorrectly. Keep these points in mind:

  • Reversing the formula: Always subtract the selling price from the cost price when calculating loss.

  • Using the wrong percentage base: Divide the loss by the original cost price, not the selling price.

  • Ignoring additional expenses: Include relevant shipping, packaging, platform fees, or other costs when calculating actual business profit or loss.

  • Dividing by zero: Use an IF function to prevent errors when the cost price is zero.

  • Entering numbers as text: Make sure your prices are stored as numeric values so Excel can calculate them correctly.

One important point: if you want to calculate your actual business loss, consider all relevant expenses instead of comparing only the purchase and selling prices.

Conclusion

Calculating loss in Excel is simple once you understand the basic subtraction formula. You can use =A2-B2 to find the difference between the cost price and selling price, or use =(A2-B2)/A2 to calculate the loss percentage.

For more advanced calculations, Excel's IF and MAX functions help you display only actual losses and avoid negative values.

Whether you're managing product sales, maintaining business records, or tracking investments, these formulas can save time and help you understand your financial results more clearly. With a properly organised Excel sheet, you can monitor losses, compare transactions, and make better financial decisions.

Frequently Asked Questions (FAQs)

1. What is the formula to calculate loss in Excel?

Use =A2-B2, where A2 contains the cost price and B2 contains the selling price.

2. How do I calculate loss percentage in Excel?

Use =(A2-B2)/A2 and format the result as a percentage.

3. How do I calculate loss automatically in Excel?

Enter =A2-B2 in the first result cell and drag the fill handle down to apply the formula to other rows.

4. How can I show only losses in Excel?

Use =IF(A2>B2,A2-B2,0) to display losses and show zero when there is no loss.

5. Can Excel calculate both profit and loss?

Yes. Use =A2-B2. A positive result indicates a loss, while a negative result indicates a profit when A2 is the cost price and B2 is the selling price.

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