# Using Logical Excel Functions in Excel 2007 Formulas

Excel 2007 uses seven logical functions — AND, FALSE, IF, IFERROR, NOT, OR, and TRUE — which appear on the Logical command button’s drop-down menu on the Excel Formulas tab of the Ribbon. All the logical functions return either the logical TRUE or logical FALSE when their functions are evaluated.

Here is an Excel functions list that shows the logical function with its argument syntax:

**AND(**tests whether the*logical1*,*logical2*,...)*logical*arguments are TRUE or FALSE. If they are all TRUE, the AND function returns TRUE to the cell. If any are FALSE, the AND function returns FALSE.**IF(**tests whether the*logical_test*,*value_if_true*,*value_if_false*)*logical_test*expression is TRUE or FALSE. If TRUE, the Excel IF function returns the*value_if_true*argument. If FALSE, the IF function returns the*value_if_false*argument.**IFERROR(**tests whether the*value*,*value_if_error*)*value*expression is an error. IFERROR returns*value_if_error*if the expression is an error, or*value*of the expression if it is not an error.**NOT(**tests whether the*logical*)*logical*argument is TRUE or FALSE. If TRUE, the NOT function returns FALSE. If FALSE, the NOT function returns TRUE.**OR(**tests whether the*logical1*,*logical2*,...)*logical*arguments are TRUE or FALSE. If any are TRUE, the OR function returns TRUE. If all are FALSE, the OR function returns FALSE.**FALSE()**— takes no argument and simply enters logical FALSE in its cell.**TRUE()**takes no argument and simply enters logical TRUE in its cell.

The *logical_test *and *logical *arguments that you specify for these logical functions usually employ the comparison operators (=, <, >, <=, >=, and <>), which themselves return logical TRUE or logical FALSE values. For example, suppose that you enter the following formula in your Excel worksheet:

=AND(B5=D10,C15>=500)

In this Excel formula, the spreadsheet program first evaluates the first *logical *argument to determine whether the contents in cell B5 and D10 are equal to each other. If they are, the first comparison returns TRUE. If they are not equal to each other, this comparison returns FALSE. The program then evaluates the second *logical *argument to determine whether the content of cell C15 is greater than or equal to 500. If it is, the second comparison returns TRUE. If it is not greater than or equal to 500, this comparison returns FALSE.

After evaluating the comparisons in the two *logical *arguments, the AND function compares the results: If *logical *argument 1 and *logical *argument 2 are both found to be TRUE, then the AND function returns logical TRUE to the cell. If, however, either argument is found to be FALSE, then the AND function returns FALSE to the cell.

When you use the IF function, you specify what’s called a *logical_test *argument whose outcome determines whether the *value_if_true *or *value_if_false *argument is evaluated and returned to the cell. The *logical_test *argument normally uses comparison operators, which return either the logical TRUE or logical FALSE value. When the argument returns TRUE, the entry or expression in the *value_if_true *argument is used and returned to the cell. When the argument returns FALSE, the entry or expression in the *value_if_false *argument is used.

Consider the following formula that uses the Excel IF function to determine whether to charge tax on an item:

=IF(E5="Yes",D5+D5*7.5%,D5)

If cell E5 (the first cell in the column, where you indicate whether the item being sold is taxable or not) contains Yes, the IF function uses the *value_if_true *argument that tells Excel to add the extended price entered in cell D5, multiply it by a tax rate of 7.5%, and then add the computed tax to the extended price. If, however, cell D5 is blank or contains anything other than the text Yes, then the IF function uses the *value_if_false *argument, which tells Excel to just return the extended price in cell D5 without adding any tax to it.

As you can see, the *value_if_true *and *value_if_false *arguments of the Excel IF function can contain constants or expressions whose results are returned to the cell that holds the IF formula.

**More about Excel:**

Excel functions vlookup

Excel macros

Excel macros video

Excel VBA functions

Excel functions subtraction

Excel date functions