How to Enter Percentage Conditions Correctly in Power Query in WPS Office Spreadsheets
Question details
The user needs to create a conditional column in Power Query to test whether a percentage value falls within a range, but percentage entries such as -5% and 5% are not accepted as expected.

- Product
- WPS Office Spreadsheets Power Query
- Device & OS
- not provided
- Scenario
- Building a conditional column in Power Query to classify percentage values within a range.
- Observed behavior
- Percentage sign entries such as -5% and 5% are not accepted as expected in the conditional expression.
Open the Power Query Editor in WPS Office Spreadsheets and confirm whether your source column is formatted as a percentage or decimal value. Power Query stores percentage values as decimals, so enter condition thresholds in decimal form rather than with a percent sign.
Enter Percentage Thresholds as Decimal Numbers in Power Query Conditional Column
Use this method when a conditional column rejects percentage signs and you need to test a range such as between -5% and 5%.
Power Query stores percentage values as decimals: -5% is stored as -0.05 and 5% as 0.05. Enter the decimal equivalents directly so the conditional expression evaluates correctly.
In the Power Query Editor, click the table query, go to the Add Column tab, and select Conditional Column.
Enter a column name, choose your percentage column, set the operator to 'is greater than or equal to', and enter -0.05 as the Value.
Select Add Clause, set the operator to 'is less than or equal to', and enter 0.05 as the Value.
Enter the values to return when the condition is true or false, click OK, review the generated formula if needed, and use Close & Load to return the results to the worksheet.

Fix Power Query Percentage Conditions in WPS Office Spreadsheets
Open the workbook in WPS Office Spreadsheets, edit the query in Power Query Editor, and enter percentage thresholds as decimal numbers such as -0.05 and 0.05 so conditional columns evaluate percentage ranges correctly.
- 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office, open the workbook containing the query, and click the Data tab to access Power Query tools.
- 2. Open Power Query Editor: Select Queries & Connections or Get Data, then open the Power Query Editor for the table you need to transform.
- 3. Create a conditional column with decimal thresholds: In the Add Column tab, select Conditional Column and enter percentage thresholds as decimals, such as -0.05 and 0.05.
- 4. Load the corrected query: Click OK, review the generated formula, and use Close & Load to load the corrected conditional column into the worksheet.

Frequently Asked Questions
Why does Power Query reject -5% and 5% in a conditional column?
Power Query stores percentage values as decimals, so conditional expressions expect decimal numbers. Use -0.05 instead of -5% and 0.05 instead of 5%.
How do I convert percentage values to decimal numbers for Power Query conditions?
Divide the percentage by 100 or move the decimal point two places to the left. For example, -5% becomes -0.05 and 5% becomes 0.05.
Can I type a percent sign in the Power Query conditional column dialog?
It is not reliable for range conditions because Power Query evaluates the underlying decimal value. Enter the decimal equivalent directly in the Conditional Column dialog.
Where is the Conditional Column option in WPS Office?
Open the Power Query Editor, go to the Add Column tab, and click Conditional Column to build a column that tests percentage or decimal values.




