WPS Spreadsheets: Use IF to Calculate a Tax-Adjusted Price
Question details
The user needs an IF formula that calculates a tax-adjusted price when an option cell contains Y and keeps the original price for other values.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A worksheet uses E7 for a Y/N selection, F7 for the original price, and G7 for the calculated result.
- Observed behavior
- The desired result is for G7 to divide F7 by 1.2 when E7 is Y and return F7 unchanged when E7 contains N or another value.
Confirm that E7 contains the option value, F7 contains the original price, and G7 is the cell where you want the calculated result to appear. Use a numeric value in F7 so the formula can perform the division correctly.
Enter the IF formula in G7
Use this solution when the tax-adjusted price should update automatically based on the value in E7.
The IF function tests whether E7 equals Y. If the condition is true, it divides F7 by 1.2; otherwise, it returns the original value in F7 without changing it.
Open the worksheet and select cell G7, or click the Name Box above the sheet, type G7, and press Enter.
Type =IF(E7="Y",F7/1.2,F7) in the formula bar or directly in G7, then press Enter.
Enter Y in E7 to calculate F7/1.2. Enter N or another value in E7 to return the original value from F7.
To apply the same logic to additional rows, select G7 and drag the fill handle downward; WPS Spreadsheets will adjust the row references automatically.
Calculate Conditional Prices with IF in WPS Spreadsheets
WPS Spreadsheets lets you enter and fill the Excel-compatible IF formula directly, so prices update automatically according to the selected option while preserving familiar spreadsheet workflows.
- 1. Open WPS Spreadsheets: Launch WPS Office and open an existing workbook or choose a blank spreadsheet.
- 2. Select the output cell: Click cell G7, where the calculated price should appear.
- 3. Enter the IF formula: Type =IF(E7="Y",F7/1.2,F7) and press Enter.
- 4. Test both conditions: Enter Y and then N in E7 to verify that the result changes between the adjusted and original prices.
Frequently Asked Questions
What formula calculates the tax-adjusted price in WPS Spreadsheets?
In G7, enter =IF(E7="Y",F7/1.2,F7) and press Enter. The formula divides F7 by 1.2 when E7 contains Y; otherwise, it returns F7.
What happens when E7 contains N?
The IF condition is false, so the formula returns the value in F7 unchanged. The same behavior applies to other values that are not Y.
Can I use this formula in Microsoft Excel?
Yes. The formula uses the standard Excel-compatible IF function and can be used in both WPS Spreadsheets and Microsoft Excel.
How do I apply the formula to more rows?
Select G7 and drag its fill handle down the column. Relative references will change to E8 and F8, E9 and F9, and so on.
