How to Calculate Price, Delivery, FSC, and Tax in One Excel Formula in WPS Office
Question details
The user needs to calculate a final invoice total in WPS Office Spreadsheet by adding base price and delivery, then applying a 1% FSC adjustment and 8.5% tax in one Excel-compatible formula.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- A user is building or correcting an Excel formula to total a price with delivery, FSC, and tax components.
- Observed behavior
- The current formula does not apply the FSC and tax percentage adjustments correctly, so the returned final total is wrong.
Confirm that the base price is in B3, delivery is in B4, FSC rate is in B5 as 0.01, and tax rate is in B6 as 0.085, or adjust the cell references in the formula to match your sheet.
Use the corrected formula =(B3+B4)*(1+B5)*(1+B6) in WPS Spreadsheets
Use this solution to make the formula add the base price and delivery first, then apply the FSC percentage and tax percentage to that subtotal in one step.
The formula groups B3+B4 inside parentheses so the base price and delivery are added before any percentage adjustments. Multiplying by (1+B5) applies the FSC rate, and multiplying by (1+B6) applies tax to the FSC-adjusted amount.
Click cell B3 and enter the base price, click B4 and enter the delivery charge, click B5 and enter 0.01 for FSC, and click B6 and enter 0.085 for tax.
Click the cell where the final total should appear, such as B7.
Type =(B3+B4)*(1+B5)*(1+B6) in the selected cell or in the formula bar.
Press Enter to calculate. With 85 as the base price and 10 as delivery, the formula returns 104.11 after applying 1% FSC and 8.5% tax.
Calculate price, delivery, FSC, and tax with one corrected formula in WPS Office
Open your Excel workbook in WPS Office Spreadsheet and use =(B3+B4)*(1+B5)*(1+B6) to return the correct final amount. WPS Office keeps Excel formulas, cell references, and formatting intact while providing a free and lightweight spreadsheet experience.
- 1. Open the Excel workbook in WPS Office: Launch WPS Office, click the Menu button in the top-left corner, choose Open, and select the Excel file that contains the price and delivery data.
- 2. Confirm the value cells: Click the sheet tab and check that B3 is the base price, B4 is delivery, B5 is the FSC rate, and B6 is the tax rate, or note the cells that match your layout.
- 3. Enter the corrected formula: Select the result cell, type =(B3+B4)*(1+B5)*(1+B6) in the formula bar, and press Enter.
- 4. Verify the final total: Check the returned final amount. For example, with 85 base price, 10 delivery, 1% FSC, and 8.5% tax, WPS Office returns 104.11.
Frequently Asked Questions
Why does my current Excel formula not apply the FSC and tax correctly?
The most common reason is that the formula does not group the base price and delivery as a subtotal before applying percentages. Use =(B3+B4)*(1+B5)*(1+B6) so WPS Spreadsheets adds B3 and B4 first, then applies FSC and tax.
How should I enter 1% FSC and 8.5% tax in WPS Spreadsheets?
Enter the rates as decimal values 0.01 and 0.085 in cells B5 and B6, or enter 1% and 8.5% with percentage cell formatting. The formula uses (1+B5) and (1+B6) to turn them into multipliers.
Can I change the formula if my values are not in cells B3, B4, B5, and B6?
Yes. Replace each reference with the cell that contains the corresponding value. For example, if the base price is in C2, delivery in C3, FSC in C4, and tax in C5, use =(C2+C3)*(1+C4)*(1+C5).
Does WPS Office support the same percentage formulas as Excel?
Yes. WPS Office Spreadsheet is compatible with Excel formula syntax and .xlsx workbooks, so you can enter =(B3+B4)*(1+B5)*(1+B6) and get the same result.
What result should I expect for an 85 price, 10 delivery, 1% FSC, and 8.5% tax?
The subtotal is 95. After applying the 1% FSC, the amount becomes 95.95, and after 8.5% tax the final total is 104.11 when rounded to two decimal places.
