PlanMaker TRUE: Logical Values and Optional Conditions
Use TRUE() in PlanMaker, distinguish logical values from text and create optional conditions that preserve mandatory worksheet rules.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =TRUE() returns PlanMaker’s logical value TRUE. It takes no arguments and does not inspect another cell. To test whether a stock count is at least ten, use a comparison such as =B2>=10.
Availability and version history
- Introduced: Documented by the PlanMaker 2010 manual; the original introduction release and date remain unknown.
- Availability: Documented in PlanMaker 2026. This identifies a documented version, not a last-working-version endpoint.
- Scope: The current entry belongs to the 2026/NX manual family; exact FreeOffice and individual mobile-build behavior is not established here.
- Checked: October 14, 2026, against the official TRUE reference and historical entry. The examples were independently calculated; no native PlanMaker test was performed.
Syntax and a real logical value
=TRUE()
Keep the parentheses empty. The function supplies a logical constant, while ="TRUE" supplies a text string. Those two values can look similar on screen without having the same stored type.
The short function reference does not establish every locale’s manual word-entry conversion. Using the formula explicitly avoids assuming that typing a word or importing a CSV produces a logical value.
Reproducible type checks
Create TrueTypes, with Input formula, Logical type and Text type in A1:C1. Enter the formulas in A2:A6 below. Put =ISLOGICAL(A2) in B2 and =ISTEXT(A2) in C2, then fill B2:C2 through row 6.
| Row | Formula in A | Expected B | Expected C |
|---|---|---|---|
| 2 | =TRUE() |
TRUE | FALSE |
| 3 | =FALSE() |
TRUE | FALSE |
| 4 | ="TRUE" |
FALSE | TRUE |
| 5 | =1 |
FALSE | FALSE |
| 6 | =2>1 |
TRUE | FALSE |
The ISLOGICAL reference tests for either logical value. Therefore B3 is TRUE even though A3’s value is FALSE. The ISTEXT reference includes a formula that returns a string, explaining C4.
These type checks do not establish how every unrelated function converts numbers or text when it needs a logical condition.
Enable a calculation without bypassing its conditions
Create StockChecks with Item, Stock, Minimum stock, Meets minimum and Enabled result in A1:E1. Enter:
| Row | A | B: Stock | C: Minimum |
|---|---|---|---|
| 2 | P1 | 12 | 10 |
| 3 | P2 | 8 | 10 |
| 4 | P3 | 10 | 10 |
| 5 | P4 | 0 | 1 |
Put Enabled in G2 and =TRUE() in H2. Enter =B2>=C2 in D2 and fill through D5. The four comparisons are TRUE,FALSE,TRUE,FALSE.
In E2 enter =AND($H$2,D2) and fill through E5. With H2 TRUE, the four results remain TRUE,FALSE,TRUE,FALSE. TRUE enables the existing rule; it does not turn insufficient stock into sufficient stock.
Change H2 to =FALSE(); E2:E5 becomes FALSE,FALSE,FALSE,FALSE, while D2:D5 stays unchanged. Restore TRUE() afterward. In F2 enter =IF(E2,"Rule passed","Rule not passed") and fill through F5. After restoration the labels are Rule passed,Rule not passed,Rule passed,Rule not passed.
An optional upper limit with an explicit neutral condition
Add Check upper limit in G3 and =TRUE() in H3. Put numeric 11 in H4. In J2 enter this formula and fill through J5:
=AND(D2,IF($H$3,B2<=$H$4,TRUE()))
With H3 TRUE, expect FALSE,FALSE,TRUE,FALSE. Item P1 exceeds the optional upper limit even though it meets the minimum. Set H3 to =FALSE(); expect TRUE,FALSE,TRUE,FALSE. The minimum requirement stays active because D2 remains a separate AND argument.
The optional branch returns TRUE when disabled. For valid logical inputs, AND(x,TRUE) preserves x. By contrast, =OR(TRUE(),D2) always returns TRUE and would bypass the stock check. Restore H3 to TRUE when finished.
Simple logical controls and limits
On TrueControls, put =TRUE() in A2 and =FALSE() in A3. Enter =AND(A2,TRUE()) in B2, =OR(A2,TRUE()) in C2 and =NOT(A2) in D2. Fill B2:D2 through row 3.
| Row | Expected B | Expected C | Expected D |
|---|---|---|---|
| 2 | TRUE | TRUE | FALSE |
| 3 | FALSE | TRUE | TRUE |
These identities describe the supplied logical values. They do not prove short-circuit evaluation or suppression of an error elsewhere in a formula. The TRUE entry also does not define the error for every malformed call or extra argument.
FALSE supplies the opposite constant. AND, OR and NOT implement the logical controls; IF chooses explicitly supplied outputs. Use the argument separator required by your installed locale.