Cost Savings Formula in Excel: Calculate and Compare

Formulas & functions · Updated November 22, 2026

To calculate cost savings in Excel, subtract the new cost from the original cost: if the original amount is in B2 and the new amount is in C2, enter =B2-C2 in D2. To show savings as a percentage of the original cost, use =IF(B2=0,0,(B2-C2)/B2) and format the result as a percentage.

What cost savings means

Cost savings is the difference between a cost before a change and the cost after it. The change might be a supplier discount, a lower monthly service fee, a process improvement, or a purchase of a more efficient product. Excel does not have a special cost-savings function; ordinary subtraction and percentage calculations are enough for most comparisons.

It helps to distinguish three measures that people sometimes call “savings” interchangeably:

  • Dollar savings: the amount by which the cost fell.
  • Percentage savings: the dollar savings divided by the original cost.
  • Net savings: the reduction in ongoing costs after accounting for implementation or other additional costs.

For example, reducing an item’s price from $250 to $200 produces $50 in dollar savings and 20% savings. If switching suppliers also requires a $30 delivery fee, the immediate net reduction is only $20. Decide which measure answers your question before building a report.

Set up a simple comparison

Use one row for each item or cost category, with clear column headings. For a basic comparison, enter the original cost in column B and the new cost in column C. Put the savings calculation in column D and the savings rate in column E. For instance, label A1 “Item,” B1 “Original cost,” C1 “New cost,” D1 “Savings,” and E1 “Savings rate.” Enter the corresponding amounts in row 2.

With the original cost in B2 and the new cost in C2, enter =B2-C2 in D2. If the original amount is $250 and the new amount is $200, the result is $50. A positive result indicates the new cost is lower; a negative result means the new cost is higher by that amount. Copy the formula down column D to calculate savings for additional rows.

With the same B2 and C2 layout, enter =IF(B2=0,0,(B2-C2)/B2) in E2. For $250 and $200, the result is 0.2, or 20% when displayed as a percentage. Select the result cells and choose Home > Number > Percentage. Increase or decrease the displayed decimal places if the report needs more precision. The formula uses zero when the original cost is zero because a percentage change from a zero baseline is undefined; that zero is a reporting convention, not a claim that a meaningful percentage saving occurred.

Calculate savings across several items

For a list of purchases, it is usually clearer to calculate each row’s savings and then total the results. Suppose original costs are in B2:B6, new costs are in C2:C6, and each row represents a comparable item or period. In D2, enter =B2-C2 and fill it through D6. If the five original amounts are $100, $200, $150, $250, and $100, and the new amounts are $90, $180, $150, $225, and $95, the row savings are $10, $20, $0, $25, and $5.

With those row results in D2:D6, enter =SUM(D2:D6) in D7 to get total savings of $60. You can also calculate the total difference directly. With original amounts in B2:B6 and new amounts in C2:C6, enter =SUM(B2:B6)-SUM(C2:C6). It also returns $60 for the example. The row-by-row approach is useful when you want to audit which items contributed to the total, while the direct approach is compact.

Do not usually average individual savings percentages to get the overall rate. A small purchase and a large purchase should not have equal influence on a total-cost percentage. With original costs in B2:B6 and new costs in C2:C6, enter =IF(SUM(B2:B6)=0,0,(SUM(B2:B6)-SUM(C2:C6))/SUM(B2:B6)) to calculate the overall rate. The example has $800 in original costs and $740 in new costs, so the result is $60 divided by $800, or 7.5%.

Include recurring and one-time costs

A lower monthly price does not always mean the change pays for itself immediately. Separate recurring savings from one-time costs such as installation, training, migration, or an early termination fee. Comparing costs over a consistent time period makes the result more useful. For example, compare twelve months of the old service with twelve months of the new service, rather than comparing one old month with a full year of new costs.

For a simple first-year estimate, suppose B2 contains monthly savings of $40 and C2 contains a one-time implementation cost of $120. Enter =B2*12-C2 in D2 to calculate first-year net savings. The result is $360: twelve months of $40 savings ($480) minus the $120 setup cost. This assumes the monthly saving occurs for all twelve months and excludes any other costs, taxes, or changes in usage.

To estimate how many months it takes for recurring savings to offset a one-time cost, put monthly savings in B2 and the one-time cost in C2. Enter =C2/B2 in D2. With $120 in setup costs and $40 saved per month, the result is 3 months. This simple payback calculation assumes savings are consistent each month. It does not account for financing, discounting, changing prices, or savings that begin partway through a month, so treat it as an estimate rather than a complete financial analysis.

Choose the right baseline and time period

The formula is only as meaningful as the comparison behind it. “Original cost” should represent the cost that would reasonably have applied without the change, and “new cost” should cover the same quantity, service level, and time period. A one-time purchase should not be compared directly with a monthly subscription unless you convert both amounts to a common period and explain the assumptions.

Check whether the figures are actual or planned. A quote compared with a previous invoice measures a potential reduction, not realized savings. Likewise, a budget estimate compared with actual spending measures variance against budget, which may have other causes. Label a result as projected, contracted, or realized so readers do not mistake an estimate for a confirmed reduction.

Keep units consistent. If one supplier charges per case and another per individual item, convert the prices to the same unit before comparing. For a recurring service, account for the number of months being assessed. If quantities changed, compare either total spend for the actual quantities or unit costs at a consistent quantity, depending on the question. A lower total bill could reflect buying fewer units rather than receiving a better price.

Format and organize the results

Good formatting makes a savings worksheet easier to check without changing the underlying calculation. Use Currency or Accounting format for cost and savings amounts, and Percentage format for savings rates. In Microsoft Excel for Microsoft 365 on Windows, select the cells and use the Number group on the Home tab. Use descriptive headers, keep the original and new figures visible, and indicate the currency if the workbook contains values from more than one currency.

Consider adding columns for date, supplier, quantity, time period, and notes when those details affect the comparison. A note such as “annual price, before tax” can prevent a reader from comparing the figure with a monthly, tax-inclusive amount. If the worksheet is shared, include the assumptions near the table rather than relying on someone to remember how a number was produced. Use consistent decimal places and avoid rounding source values before calculating; format the display instead.

For a quick visual review, you can use conditional formatting to distinguish positive savings from cost increases. Select the savings cells and choose Home > Conditional Formatting > Highlight Cells Rules. Set rules that fit the worksheet’s conventions, and retain the numeric values so the colors are not the only way to interpret the results. On Mac, the same general conditional-formatting options are available from the Home tab, though the ribbon layout may vary slightly. Excel for the web also supports common number formats and conditional formatting, but some controls can appear in a different location.

Common calculation mistakes

The most frequent percentage mistake is dividing the savings by the new cost instead of the original cost. If a price falls from $250 to $200, the reduction is $50. The conventional savings rate is $50 divided by $250, or 20%; dividing by $200 gives 25%, a different ratio that does not describe the reduction as a share of the starting cost.

Other errors often come from the data rather than the arithmetic:

  • Reversed columns: Subtracting original cost from new cost changes the sign. Keep the order consistent: original minus new.
  • Nonmatching periods: A monthly cost and an annual cost cannot be compared directly without converting one.
  • Omitted charges: Freight, setup fees, service charges, or required add-ons can reduce or eliminate apparent savings.
  • Changed quantity or scope: A cheaper total may reflect less service, fewer units, or a different specification.
  • Blank or zero baselines: A zero starting value cannot produce a meaningful percentage reduction. Review those rows instead of treating a displayed zero as a valid rate.
  • False precision: A displayed percentage with many decimal places does not make estimates more certain. Match the display precision to the quality of the source data.

When a result looks surprising, inspect the two source values, their units, and the formula bar. A cell formatted as a percentage can display 20% even though its stored value is 0.2; that is normal. Formatting changes how a number appears, not the calculation itself.

When a basic savings formula is not enough

Subtraction works well for a straightforward before-and-after comparison, but complex decisions may require more detail. If costs vary by month, build a period-by-period table. If the new option has an initial investment and savings continue over several years, include the timing of each cash flow rather than relying only on a simple payback period. If usage, service levels, or prices may change, use clearly labeled scenarios instead of presenting one forecast as certain.

A cost reduction is also not automatically a net financial benefit. It may involve a trade-off in quality, reliability, staffing, or risk that the savings cells do not capture. The spreadsheet can compare amounts based on the assumptions supplied, but it cannot establish whether those assumptions are appropriate. For financial decisions, check actual terms with the lender or a qualified professional; the examples here are illustrative and are not financial, tax, investment, or legal advice.

Frequently Asked Questions

What is the formula for calculating savings in Excel?
Subtract the new cost from the original cost. If the original cost is in B2 and the new cost is in C2, use =B2-C2. A positive result means the new cost is lower; a negative result means it increased.

How do I calculate cost savings as a percentage?
Divide the difference between the original and new costs by the original cost. With the original amount in B2 and the new amount in C2, use =IF(B2=0,0,(B2-C2)/B2), then format the result as a percentage. Check zero-baseline rows separately because their percentage is undefined.

How do I calculate total savings for multiple items?
Calculate each row’s original cost minus its new cost, then add the savings cells with SUM. For example, if the row calculations are in D2:D6, use =SUM(D2:D6). Make sure the compared items and periods are consistent.

Should I average the savings percentages?
Usually not when you want the percentage saved across a group of costs. Calculate total savings divided by total original cost instead. That weights each item according to its original cost, unlike a simple average that gives a small purchase the same weight as a large one.

How do I include a setup fee in savings?
Subtract the one-time fee from the savings over the period being evaluated. For a simple first-year estimate, if B2 is monthly savings and C2 is the setup fee, use =B2*12-C2. Include other relevant costs and label the assumptions used.

Why does my savings result show as a negative number?
A negative result from original cost minus new cost means the new cost is higher. Check that the original and new columns are not reversed, then confirm that the figures cover the same unit, quantity, and time period.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.