Brother Ensemble PDP-100J, Owner'S Manual

Page: 394 / 440

Appendix 367
Logical Functions
The logical functions evaluate relationships and return true" or false"
results. True = 1 (or non-zero values) and false = 0. The main purpose of
logical functions is the IF() function, which evaluates any of the logical
functions in order to take a specified action.
Function Description
True = 1 (or non–zero),
False = 0
Example
AND
(logical1,
logical2,...)
LogicalAND. Returns 1 if all arguments are true
or 0 is any of the arguments is false. Useful with
IF statements. Logical can be either logical
values, arrays or references to cells or fields that
contain logical values. Text is ignored. If the
argument does not contain a logical value, AND
returns the #TYPE# error. See also OR. You can
have as many logical arguments as you want.
=AND(1+3=4,3+1=3) returns 0.
=AND(1+3=4,3+1=4) returns 1.
=IF(AND(A1>B1,A1<C1),100,200) returns 100 if
A1 is greater than B1 and less than C1.
Otherwise, it returns 200.
FALSE
( )
Returns 0 . You can use FALSE in a calculation
or enter it directly into a cell or field where it is
interpreted as a logical value. You must include
the empty parentheses. See also TRUE.
IF
(logical, true
value, false value)
Evaluates a condition, returning onespecified
value if true and another if it is false . Logical
is any expression or value that can be evaluated
as true or false. True_value is the value returned
if the logical expression is true. False_value is
the value returned if the logical expression is
false.
=IF(B13=500,50,-50) returns 50 if B13 contains
500. Otherwise, the expression returns -50.
=IF (D14 = warm",red",yellow") returns red if
D14 contains warm". Otherwise, the expression
returns yellow.
=IF (A1>A2,Ascending",Descending") returns
Ascending if A1 is greater than A2. Otherwise
the expression returns Descending.
OR
(logical1,
logical2,...)
Returns 1 if at least one of the arguments is
true or 0 if all of the arguments are false. The
arguments can be values, cells or field
references. You can have as many logical
arguments as you want. OR ignores text. If an
argument does not contain a logical value, OR
returns the #TYPE# error. OR is particularly
useful with IF expressions. See also AND.
=OR(1+2=3,2+3=5) returns 1.
=OR(1+2=3,2+3=4) returns 1.
=OR((1+2=2,2+3=3) returns 0.
=IF(OR(A1>100,A1=B1),25,50) returns 25 if A1 is
100 or less, or A1 equals B1.
TRUE
( )
Returns 1 . You can use TRUE in a calculation
or enter it directly into a cell or field where it is
interpreted as a logical value. You must include
the empty parentheses. See also FALSE.