Function Problems

How to Test Multiple Conditions in Order and Return a Blank in Excel

Aamir Naveed AkramAamir Naveed Akram Nov 13, 2026 868 views

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.

How to Test Multiple Conditions in Order and Return a Blank in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the result cell

Click the cell where you want the result to appear, for example C2.

2
Enter the IFS formula

Type =IFS(A2="High","Priority",B2>100,"Review",TRUE,"") and press Enter. Replace the conditions and values with your own ordered rules.

3
Copy the formula down

Drag the fill handle from the bottom-right corner of the cell down to apply the same ordered test to other rows.

Blank result: If no listed condition is TRUE, the final TRUE argument returns an empty string, so the cell stays blank.
WPS Spreadsheet formula tips

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. 1. Open your workbook in WPS Spreadsheet: Launch WPS Office and open the Excel workbook, or create a new Spreadsheet file.
  2. 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. 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. 4. Save in Excel format: Click Menu > Save As and choose Excel Workbook (*.xlsx) so the file stays compatible with Microsoft Excel.
Test ordered conditions with IFS and nested IF formulasReturn blank cells cleanly with an empty-string fallbackSplit text at the earliest matching delimiter using named rangesFull compatibility with Microsoft Excel .xlsx workbooks
microsoft office alternative - wps office

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.