TRUE in WPS Spreadsheet: Logical Constants and Explicit Decision Flags
Use the WPS TRUE constant correctly, distinguish a constant from a comparison, and build explicit numeric indicators without claiming a value was validated.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =TRUE() returns the logical value TRUE and takes no arguments. It does not inspect another cell or test a condition by itself. A comparison such as =A2>=60 can produce either TRUE or FALSE, depending on A2.
Availability and version history
- Introduced: documented by 2019-06-06 in the official WPS lesson; original introduction is not established.
- Availability: WPS Office for Windows Personal; no numeric release is stated in the edition metadata.
- Scope: exact current supported builds remain unverified. The Windows lesson does not establish equivalent availability in other WPS clients.
- Checked: October 14, 2026 against function-specific documentation. Examples were independently calculated; no native WPS test was performed.
Syntax and first controls
=TRUE()
=FALSE()
=NOT(TRUE())
Expected results are TRUE, FALSE and FALSE. The parentheses belong to the function call even though there is no argument between them. The WPS lesson also permits the logical keyword TRUE directly in a cell or formula; quoted "TRUE" is text rather than this logical constant.
Examples use English function names and comma separators. Keep input values in their own cells. Displayed expectations are documentation-based Boolean calculations, not recorded native WPS results.
Example 1: distinguish a constant from a test
Enter scores 59, 60 and 75 in A2:A4. In B2 enter =A2>=60 and fill down. In C2 enter =TRUE() and fill down:
| Score | Comparison in B | Constant in C |
|---|---|---|
| 59 | FALSE | TRUE |
| 60 | TRUE | TRUE |
| 75 | TRUE | TRUE |
The constant column says nothing about the scores. Only the comparison expresses the chosen threshold. Changing a score to 40 does not change TRUE() itself.
The official lesson’s walkthrough appears to put a comparison in the same D3 cell it references. Avoid that self-reference: this guide uses A for the score and B for the comparison. TRUE’s parameterless definition remains distinct from a condition that returns a Boolean.
Example 2: make both outcomes explicit
=IF(A2>=60,TRUE(),FALSE())
Filled down the same three scores, expected results are FALSE, TRUE and TRUE, matching the simpler comparison in column B. The explicit branches can help explain a rule, but the IF wrapper is unnecessary if the comparison itself is the desired result.
Compare =IF(TRUE(),12,99), whose expected result is 12. That is an unconditional choice because its logical test is the TRUE constant. It should not be presented as evidence that a score, approval or external condition was checked.
Advanced example: convert a Boolean report into numeric indicators
For B2:B4 containing the three comparison results, put this in D2 and fill down:
=IF(B2,1,0)
Expected indicators are 0, 1 and 1, with total 2. This conversion is explicit: it does not assume every summing context automatically treats Boolean cells the same way.
If the three observations are the complete intended population, the proportion meeting the threshold is 2/3, approximately 0.666666667. The denominator is the number of valid observations in this fixture, not simply the number of cells that happen to display something.
Advanced check: see how a constant combines with a comparison
=AND(TRUE(),A2>=60)
=OR(TRUE(),A2>=60)
Across the scores 59, 60 and 75, the first produces FALSE, TRUE and TRUE; the second produces TRUE, TRUE and TRUE. A true condition leaves an AND requirement dependent on the remaining condition, while it is already enough to satisfy OR.
These controls use valid, simple Boolean expressions. They do not prove that an application skips evaluating other arguments after seeing TRUE. Do not use an always-true argument as a supposed shield against a failing expression elsewhere in the formula.
Advanced example: use a final unconditional IFS branch
For a numeric score in A2:
=IFS(A2>=90,"A",A2>=60,"B",TRUE(),"C")
For 45, 72 and 95, expected labels are C, B and A. TRUE() supplies a condition that matches whatever remains after earlier conditions have priority. Moving the unconditional pair to the beginning would select C for every listed score.
The final pair is still a condition/result pair, not an independent check of data validity. A score outside the intended domain needs its own explicit rule.
Limits and related functions
A genuine Boolean result is different from a text label, an error, a missing response or a visually styled checkbox. This guide does not certify every import, checkbox configuration or text-to-Boolean coercion rule.
Use IF to choose an outcome, AND or OR to combine comparisons, and NOT to reverse one. TRUE() supplies the constant; the surrounding expression supplies the meaning.
References and verification
- WPS Academy: TRUE lesson, 2019-06-06 (Chinese; Windows Personal scope).
- Editorial testing standards.
Worked outputs are independently calculated expectations, not captured native results. The dated source establishes the stated product scope, not every current client or build.