How to Test Multiple Conditions in Order and Return a Blank in Excel
Question details
The user needs to evaluate several conditions from left to right in Excel or WPS Spreadsheet and return a blank when none are met, including delimiter-based text splitting.

- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- Evaluating ordered logical tests or delimiter checks in a spreadsheet formula and needing a clean result without errors, FALSE, or zero.
- Observed behavior
- The formula should return the value from the first matching condition or split text at the earliest matching delimiter, and stay blank if no condition is satisfied.
Open your workbook in WPS Spreadsheet and confirm that your conditions are in separate cells or that the delimiter characters are available. If you plan to use the delimiter method, create a named range such as delim before entering the formula.
Use the IFS Function to Test Multiple Conditions in Order
Best for clean, readable formulas when you need to evaluate conditions from left to right and return a blank if none match.
IFS returns the value for the first TRUE condition and supports a TRUE final condition as the blank fallback. WPS Spreadsheet supports IFS in current versions.
Click the cell where you want the result to appear, for example C2.
Type =IFS(A2="High","Priority",B2>100,"Review",TRUE,"") and press Enter. Replace the conditions and values with your own ordered rules.
Drag the fill handle from the bottom-right corner of the cell down to apply the same ordered test to other rows.
Use Nested IF Functions for Ordered Tests with a Blank Result
Works when you need compatibility with older WPS Spreadsheet or Excel versions and want a simple conditioned blank fallback.
Find the Earliest Matching Delimiter and Return Left or Right Text
Use this when the multiple conditions are delimiter characters in text, and you need to split at the first match or return a blank if none is found.
Evaluate Ordered Conditions in WPS Spreadsheet and Return a Blank
You can test multiple conditions in order and leave a cell blank directly in WPS Spreadsheet using IFS, nested IF, or delimiter search formulas. WPS Office preserves your workbook formulas in Microsoft Excel-compatible .xlsx format.
- 1. Open your workbook in WPS Spreadsheet: Launch WPS Office and open the Excel workbook, or create a new Spreadsheet file.
- 2. Enter an ordered condition formula: Click the result cell and type =IFS(A2="High","P1",A2="Mid","P2",TRUE,"") to check conditions from left to right and return a blank if none match.
- 3. Apply the formula to the data range: Drag the fill handle down or across to copy the formula to the remaining rows or columns.
- 4. Save in Excel format: Click Menu > Save As and choose Excel Workbook (*.xlsx) so the file stays compatible with Microsoft Excel.

Frequently Asked Questions
Can I use the IFS function in WPS Spreadsheet?
Yes. Current WPS Spreadsheet versions support IFS. Select the result cell, type =IFS(condition1,value1,condition2,value2,TRUE,""), and press Enter.
How do I return a blank instead of FALSE or 0 in Excel?
Add an empty string as the final result in IF or IFS, for example =IF(A2>10,"Yes","") or =IFS(A2>10,"Yes",TRUE,"").
How can I test delimiter characters in order and split text?
Create a named range called delim containing the delimiter characters, then use a formula with SEARCH, IFERROR, MIN, and MID or LEFT to split at the earliest matching delimiter.
Why does my nested IF formula return FALSE?
A nested IF returns FALSE when no condition is TRUE and no final else value is supplied. Add "" as the last argument, such as =IF(A2="Yes","Approved","").
Will these formulas work when I open the workbook in Microsoft Excel?
Yes. WPS Spreadsheet saves standard formulas in Excel-compatible .xlsx format. Legacy array formulas may still need to be confirmed with Ctrl+Shift+Enter when opened in older Excel versions.




