Manual

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 FALSEin 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