Table of Contents
Advertisement
Logical Functions,
The logical functions evaluate relationships and return true or false results.
True= 1 (or nonzero values) and false = 0.
A logical function uses a conditional
statement; for example,
if this is true
then do that. An example
of a lo[_ical function would be this conditional
statement:
if the value in B12 is larger than 10,000, then display 50 in this cell.
Description
True = 1 (or nonzero), False = 0
Function
AND
(logicall,
IogicatZ,...)
FALSE ( )
IF (tog/ca/,true
value, faise
value)
OR (logicaH ,
_:
logical2,...)
TRUE()
Logical AND. Returns 1 if all arguments
are true or 0 if any is false. Useful with IF
statements.
Logical can be either logical values, arrays or references
to cells 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/ogical
arguments
as you want.
Returns
O. You can use FALSE in a calculation
or enter it directly into a cell where it
is interpreted
as a logical value. You must include the empty parentheses.
See also
TRUE.
.
Evaluates
a condition,
returning
one specified
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.
Returns
1 if at least one of the arguments
is true or 0 if all of the arguments are
false.The
arguments
can be-'3,-d.luesor-cells. 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 #'rYPE# error. OR is particularly
useful with IF expressions.
See also AND.
Returns
1. You can use TRUE in a calculation
or enter
it directly
into a cell where
it
is interpreted
as a logical
value.
You must
include
the empty
parentheses.
See also
FALSE.
Logical
Function
example:
IF statements
IF statements
consist
of the following:
•
The condition
you want
to test
•
The result
you want
if the condition
is true
•
The result you want
if the condition
is false
For example,
you might calculate
escalating
bonuses
for a sales team
based
on a percentage
of the sales,
located
in cell C4. For sales
under
$10,000,
the
bonus
is 2%.
Appendix
220
Advertisement
Table of Contents
