Excel 2000 in a Nutshell

Chapter 19. Logical Functions

Excel provides six functions designed to return a logical value. TRUE and FALSE simply return the specified value. The other functions return a value based on the results of a condition. Typically these functions are going to be combined with other Excel functions.

The following functions are covered in detail in this chapter:

AND	IF	OR
FALSE	NOT	TRUE

Use these functions to do the following:

• Compare two logical expressions

• Always return a value of TRUE or FALSE

• Reverse the value returned by an argument

The Logical Functions

Excel provides six logical functions to use within a worksheet. These functions, which are covered in the remaining portion of this chapter, are categorized as follows:

Compare conditions:

AND (returns TRUE if all arguments evaluate as TRUE)

IF (performs conditions based on whether results are TRUE or FALSE)

OR (returns TRUE if at least one argument evaluates as TRUE)

Return a specific logical value:

FALSE (always returns a value of FALSE)

NOT (reverses the value of the argument)

TRUE (always returns a value of TRUE)