Calculation Issues

Calculate Software and Support Costs from a Total in Excel

Chanuka GeekiyanageChanuka Geekiyanage Nov 20, 2026 869 views

Question details

Calculate the software price and support cost from a combined purchase total when support is a percentage of the software price.

Calculate Software and Support Costs from a Total in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
A purchase total includes software and support, with support calculated as a percentage of the software price.
Observed behavior
The desired result is a software price and support cost that add up to the total and reflect the specified support rate.
Before you start

Confirm that the support percentage is based on the software price, not the total. Have the total purchase amount and support rate ready to enter in separate cells.

Solution 1Recommended

Split the total using a variable support rate in Excel

Use cell references to recalculate both costs whenever the total or support percentage changes.

The total equals the software price multiplied by 1 plus the support rate. Dividing the total by that factor gives the software price.

1
Enter the total

In Excel, enter the total purchase amount in cell A1, such as 100000.

2
Enter the support rate

In cell B1, enter the support rate as 20% or 0.2. Do not enter 20 unless you intend a rate of 2,000%.

3
Calculate the software price

In cell C1, enter =A1/(1+B1) and press Enter.

4
Calculate the support cost

In cell D1, enter =A1-C1 and press Enter. For a total of 100,000 and a 20% rate, the displayed results are approximately 83,333.33 for software and 16,666.67 for support.

Split the total using a variable support rate in Excel
Display currency amounts: Select C1:D1 and use Home > Number to apply a currency format and display two decimal places. Formatting changes the display, not the underlying values.
WPS Spreadsheets

Calculate Software and Support Costs in WPS Spreadsheets

Use the same cell formulas in WPS Spreadsheets to split a purchase total by a variable support rate.

  1. 1. Open a spreadsheet: Open WPS Spreadsheets and create a blank workbook or open an existing Excel file.
  2. 2. Enter the inputs: Enter the purchase total in A1 and the support rate in B1, using a percentage such as 20%.
  3. 3. Calculate the software price: Enter =A1/(1+B1) in C1 and press Enter.
  4. 4. Calculate the support cost: Enter =A1-C1 in D1 and press Enter. Select C1:D1 and apply a currency format if needed.
Recalculate software and support costs when the total or rate changesOpen and save Microsoft Excel XLSX filesUse familiar spreadsheet formulas and cell referencesFormat the results as currency
microsoft office alternative - wps office

Frequently Asked Questions

Why isn't the support cost 20% of the total?

The rate applies to the software price, not the combined total. For a 20% rate, the total is 120% of the software price, so divide the total by 1.2 to find the software price.

Can I calculate the costs without a separate rate cell?

Yes. If the total is in A1 and the rate is fixed at 20%, enter =A1/1.2 for the software price and =A1-A1/1.2 for the support cost.

What happens if the support percentage changes?

Change the value in B1, for example from 20% to 15%. The formulas =A1/(1+B1) and =A1-C1 will recalculate automatically.

How can I show the results to two decimal places?

Select the result cells and use Home > Number in Excel to apply a number or currency format with two decimal places. The underlying values remain unrounded.