Loading ...
Loading ...
Loading ...
92
Logical functions
Logical functions let you use conditions in building
formulas. Use them when you want the outcome of a
computation or a returned value to determine some
other value assignment or to control the sequence of
operations. You can also use logical functions to
determine values and control operations when error
conditions occur and when special input types are used.
Using logical functions to test for such conditions helps
you avoid errors which might otherwise ripple through-
out the spreadsheet.
AND(values...)
Evaluates each of the arguments. Returns TRUE if
all the arguments are TRUE; returns FALSE if one
or more is FALSE.
Example: AND( TRUE(), TRUE(), FALSE() )
returns FALSE.
FALSE()
Returns the logical value FALSE.
IF(cond, true,
false
)
Evaluates the cond expression. If cond is true, it
evaluates and returns the value of true part.
Otherwise, it evaluates and returns the value of
false
part or FALSE if
false
part is omitted.
Example: IF( B5>5, “Bigger”, “Smaller” ) returns
“Bigger” if B5 is greater than 5, and “Smaller”,
otherwise.
IF( A1, “OK” ) returns “OK” if A1 is TRUE and
FALSE, otherwise.
IF( B1>A1, 24*(B1-A1), 24-24*(A1-B1)) is an
example of a more complicated IF function.
NOT(value)
Reverses the logical value of its argument.
Example: NOT( FALSE() ) returns TRUE.
OR(values...)
Returns TRUE if one or more of the arguments is
TRUE; returns FALSE if all arguments are FALSE.
Example: OR( FALSE(), TRUE() ) returns TRUE.
TRUE()
Returns the logical value TRUE.
Loading ...
Loading ...
Loading ...