Excel IF Formula with Blank Cells, Greater-Than Tests, and SUM in WPS Office
Question details
The user needs an Excel IF formula that returns 0 when a referenced cell is blank, and otherwise performs a SUM that changes depending on whether the cell value is greater than 10.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- A user is building a spreadsheet formula that checks cell A2 for a blank value, returns zero if blank, and selects between SUM(A1,B1) or SUM(A1,C1) when A2 exceeds 10.
- Observed behavior
- The formula should evaluate blank cells correctly and choose the appropriate SUM range based on the greater-than-10 condition.
Open your workbook in WPS Office Spreadsheet and confirm that A2 is either truly empty or contains a numeric value, and that A1, B1, and C1 contain the numbers you intend to sum.
Use a Nested IF Formula for Blank, Greater-Than, and SUM Logic
Use this when you need the clearest formula that explicitly checks a blank cell, tests whether the value exceeds 10, and returns the correct SUM result.
The formula first tests whether A2 is empty. If true, it returns 0. If A2 contains a value, it checks whether that value is greater than 10 and then selects SUM(A1,B1) or SUM(A1,C1).
Click the cell where you want the result to appear, such as D1.
Type =IF(A2="",0,IF(A2>10,SUM(A1,B1),SUM(A1,C1))) and press Enter.
Test with A2 blank, with A2 set to a value greater than 10, and with A2 set to 10 or lower to confirm the formula returns 0 or the expected SUM.
Use a Shorter IF and SUM Combination Formula
Use this when you want the same logic with a more compact formula and fewer nested IF functions.
Apply Excel IF and SUM Formulas in WPS Office Spreadsheet
WPS Office Spreadsheet supports the same Excel IF, blank-cell, comparison, and SUM formulas, so you can create this conditional calculation without changing your workbook logic.
- 1. Open your workbook in WPS Office Spreadsheet: Launch WPS Office, open the Excel workbook, and go to the sheet containing the formula cells.
- 2. Select the result cell: Click the cell where you want the calculated result, for example D1.
- 3. Enter the IF formula: Type =IF(A2="",0,IF(A2>10,SUM(A1,B1),SUM(A1,C1))) in the formula bar and press Enter.
- 4. Save the workbook: Press Ctrl+S to save the workbook in its original .xlsx format.
Frequently Asked Questions
How do I write an IF formula that returns 0 if a cell is blank?
Use =IF(A2="",0,...). In WPS Office Spreadsheet, select the result cell, type the formula, and replace A2 with the cell you want to test.
Can this formula be used in both WPS Office and Microsoft Excel?
Yes. The formula uses standard Excel functions and is compatible with .xlsx workbooks in both WPS Office Spreadsheet and Microsoft Excel.
Why does my formula show FALSE instead of a number when A2 is empty?
The FALSE result usually means the IF function is missing the value_if_false argument. Use =IF(A2="",0,IF(A2>10,SUM(A1,B1),SUM(A1,C1))) so the blank case returns 0.
How do I test the greater-than-10 condition correctly?
Enter different values in A2: leave it blank, enter 11, and enter 10. The formula should return 0 for blank, SUM(A1,B1) for 11, and SUM(A1,C1) for 10.
