Calculate Software and Support Costs from a Total in Excel
Question details
Calculate the software price and support cost from a combined purchase total when support is a percentage of the software price.

- 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.
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.
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.
In Excel, enter the total purchase amount in cell A1, such as 100000.
In cell B1, enter the support rate as 20% or 0.2. Do not enter 20 unless you intend a rate of 2,000%.
In cell C1, enter =A1/(1+B1) and press Enter.
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.

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. Open a spreadsheet: Open WPS Spreadsheets and create a blank workbook or open an existing Excel file.
- 2. Enter the inputs: Enter the purchase total in A1 and the support rate in B1, using a percentage such as 20%.
- 3. Calculate the software price: Enter =A1/(1+B1) in C1 and press Enter.
- 4. Calculate the support cost: Enter =A1-C1 in D1 and press Enter. Select C1:D1 and apply a currency format if needed.

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.




