ISBLANK in WPS Spreadsheet: Empty Cells, Empty Text and Required-Field Checks

• Introduced: documented by 2019-05-14 in official WPS material; original introduction is not established.
• Availability: Windows Personal is named in the dedicated lesson metadata.
• Scope: exact current supported builds remain unverified; this evidence does not establish equivalent behavior across every WPS client.
• Checked: October 14, 2026 against complete function-specific documentation. Examples are independently modeled; no native WPS test was performed.

=ISBLANK(value)

The argument is the value or reference to test. The formal WPS reference specifically describes an empty-cell reference. Its walkthrough uses the Chinese word 空格 loosely; it should not be read as a promise that a cell containing a literal space is empty. The lesson’s “FLASE” spelling is an editorial typo for FALSE.

Examples use English function names and comma separators. Clear the designated empty cells completely and keep formulas outside them. Outputs are independent type models based on the documented definition, not native WPS captures.

Set up A2:A9 exactly as follows. In B2 enter =ISBLANK(A2) and fill down.

Only A2 is genuinely empty. A3 contains a formula with an empty-text result, and A4 contains one ordinary space. An error is also a value requiring attention, rather than an empty cell.

To count these blank flags explicitly, put =IF(B2,1,0) in C2 and fill down. Expected indicators are 1, 0, 0, 0, 0, 0, 0 and 0, totaling 1.

Replace A3’s formula with a genuinely empty cell by clearing its content. Its expected ISBLANK result changes from FALSE to TRUE, and the blank-flag total becomes 2.

Entering ="" in that cell again restores the original count of one. The two worksheet displays may look alike, but the stored inputs differ. Hiding a zero through formatting similarly does not turn the underlying numeric value into an empty cell.

These controls do not establish the result of every function with an omitted argument. In particular, an undocumented “blank” return from another function must not automatically be equated with either a cleared cell or an explicit empty string.

Create a separate E1:F6 table:

Clear the two cells labeled genuinely empty; do not type those words. In G2 enter and fill down:

=OR(ISBLANK(E2),ISBLANK(F2))

Expected results are FALSE, TRUE, TRUE, FALSE and FALSE. The second and third records contain a physically empty required field. The final two text inputs are not caught by this particular rule.

This is a useful empty-cell audit, but it is not yet a complete “meaningful item name” validation. A record with empty text or spaces may still need review even though neither cell is physically empty.

For an already verified text-only control containing Alpha, empty text and one ordinary space, the expression =LEN(TRIM(E2))>0 has expected results TRUE, FALSE and FALSE. That explicitly asks whether ordinary-space trimming leaves any characters, rather than asking whether the cell itself is empty.

ISTEXT can help classify the input before such a text policy is applied. TRIM has its own character scope; this example does not certify removal of every Unicode whitespace character.

Keep a physical-blank flag and a meaningful-content flag separately if both distinctions matter. A single catch-all replacement can make an incomplete record appear complete without explaining why it was rejected.

If a visually empty cell returns FALSE, inspect its formula bar for a formula, space or other stored content. If a zero or error is invisible because of formatting, inspect the underlying value before changing the test.

These are scalar controls. Merged cells, array references, imported special values and every application’s display behavior remain outside the verified scope. Use ISNUMBER for numeric type, ISERROR for errors and IF for an explicit reporting label; they answer different questions.

• WPS Academy: ISBLANK, 2019-05-22 (Chinese; edition scope as stated above).
• WPS Academy: shared IS-function syntax and nonconversion rule, May 14, 2019 (Windows Personal).
• Editorial testing standards.

The source establishes the cited product behavior and documented history, not a native-tested current release. Additional linked functions retain their own evidence scopes.