Logical

IF with a TRUE or FALSE branch

An IF with a TRUE or FALSE branch can often be written with AND or OR; this is only a hint, because sometimes the IF is clearer.

What MaxCheck detects

An IF where one branch is TRUE or FALSE and the other is an expression. IFs already caught by L_TTEF are skipped.

Why it hurts

It can often be written with AND / OR, which is shorter. Sometimes the IF is clearer, so this is only a hint.

Example

Taken from the rule's own test cases: formulas it must flag, and formulas it must not.

HintFlags this(else false)

IF A THEN B ELSE FALSE
  • Format: Boolean

Fine (a name starting with TRUE)

IF A THEN B ELSE TRUE_FLAG
  • Format: Boolean

How to fix

Consider AND / OR: IF a THEN b ELSE FALSE is a AND b; IF a THEN TRUE ELSE b is a OR b.

Severity
HintShown in the report. Hints never count toward a score.
Area
Logical
Runs in
Basic and full check
Rule ID
L_TTEF_light
Version
Rule 1.0.0, rule set 1.4.0

Does your model do this?

Upload the line-items blueprint. This rule runs in the basic check, in your browser, with no email.

Check your model