Formulas and Functions

Function Description
“ISEVEN” (page 162) The ISEVEN function returns TRUE if the value is
even (leaves no remainder when divided by 2);
otherwise it returns FALSE.
“ISODD” (page 163) The ISODD function returns TRUE if the value
is odd (leaves a remainder when divided by 2);
otherwise it returns FALSE.
“NOT” (page 164) The NOT function returns the opposite of the
Boolean value of a specied expression.
“OR” (page 165) The OR function returns TRUE if any argument is
true; otherwise it returns FALSE.
“TRUE” (page 166) The TRUE function returns the Boolean value
TRUE. This function is included for compatibility
with tables imported from other spreadsheet
applications.
AND
The AND function returns TRUE if all arguments are true, and FALSE otherwise.
AND(test-expression, test-expression…)
 test-expression: An expression. test-expression can contain anything as long as the
expression can be evaluated as a Boolean. If the expression evaluates to a number, 0
is considered to be FALSE, and any other number is considered to be TRUE.
 test-expression…:Optionally include one or more additional expressions.
Usage Notes
The AND function is equivalent to the logical conjunction operator used in Â
mathematics or logic. It rst evaluates each test-expression. If all the given
expressions evaluate to TRUE, the AND function returns TRUE; otherwise FALSE.
Examples
=AND(TRUE, TRUE) returns TRUE because both arguments are true.
=AND(1, 0, 1, 1) returns FALSE because one of the arguments is a numeric 0, which is interpreted as
FALSE.
=AND(A5>60, A5<=100) returns TRUE if cell A5 contains a number in the range 61 to 100, otherwise
FALSE.
The following two IF functions will return the same value:
=IF(B2>60, IF(B2<=100, TRUE, FALSE), FALSE)
=IF(AND(B2>60, B2<=100), TRUE, FALSE)
15 6 Chapter 7 Logical and Information Functions