How to Create a Single-Cell WPS Excel Formula for Sequential Percentage and Multiplication
Question details
The user needs a single Excel formula that first reduces 6,500 by 10%, then multiplies the reduced amount by 34 and 3.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is building a worksheet calculation and wants to combine percentage reduction and multiplication in one cell instead of using helper columns.
- Observed behavior
- The desired result is to calculate 6,500 × 90% × 34 × 3 and return 596,700.
Confirm whether the values 6,500, 10%, 34, and 3 are constants or stored in worksheet cells. Replace the constants with the appropriate cell references in the formula if the data will change.
Use =6500*(1-10%)*34*3 in a single WPS spreadsheet cell
Use this solution when all values are fixed constants and you need the result 596,700 without creating helper columns.
The formula applies the percentage reduction first, then performs the remaining multiplication in left-to-right order. This gives the same result as calculating 6,500 × 90% = 5,850, then 5,850 × 34 × 3.
Open the WPS Office Spreadsheets workbook and select the cell where you want the result to appear.
Type =6500*(1-10%)*34*3 into the selected cell and press Enter.
Confirm the cell returns 596,700. This equals 6,500 × 90% × 34 × 3.
If your data is in cells, replace the constants, for example =A1*(1-B1)*C1*D1, where A1 holds 6,500, B1 holds 10%, C1 holds 34, and D1 holds 3.
Create a combined percentage and multiplication formula in WPS Spreadsheets
WPS Office Spreadsheets supports the same Excel-style formulas, so you can enter =6500*(1-10%)*34*3 directly in one cell to get 596,700, without helper columns.
- 1. Open WPS Office Spreadsheets: Launch WPS Office and open a blank workbook or the existing .xlsx file where the calculation is needed.
- 2. Select the result cell: Click the cell that should display the calculated amount.
- 3. Enter the Excel-compatible formula: Type =6500*(1-10%)*34*3 and press Enter. The result 596,700 appears immediately.
- 4. Use cell references for flexible data: Replace constants with references such as =A1*(1-B1)*C1*D1 so the formula updates when source values change.
Frequently Asked Questions
Can I use this formula with cell references instead of hard-coded numbers?
Yes. Put 6,500 in A1, 10% in B1, 34 in C1, and 3 in D1, then enter =A1*(1-B1)*C1*D1.
Why does (1-10%) represent a 10% reduction?
The expression (1-10%) evaluates to 0.90, so multiplying 6,500 by 0.90 gives the reduced amount 5,850 before the remaining multiplication.
What is the result of =6500*(1-10%)*34*3?
It returns 596,700: 6,500 × 90% = 5,850, then 5,850 × 34 × 3 = 596,700.
Does WPS Office support this Excel formula syntax?
Yes. WPS Spreadsheets is compatible with Excel formulas and .xlsx workbooks, so the same formula works without changes.
Can I change the percentage to another value?
Yes. Replace 10% with any percentage or a cell reference containing the discount rate, such as =6500*(1-B1)*34*3.
