Microsoft Office Tutorials and References

In Depth Information

**Examples of Logical Functions**

Examples of Logical Functions

With only eight functions, the logical function group is one of the smallest

in Excel. The IF function is easy to understand, and it enables you to solve a

variety of problems.

Using the

Using the
IIF
Function to Make a Decision

Function to Make a Decision

Many calculations in our lives are not straightforward. Suppose that a

manager offers a bonus program if her team meets its goals. Or perhaps a

commission plan offers a bonus if a certain profit goal is met. You can solve

these types of calculations by using the IF function.

Syntax

IF(logical_test,value_if_true,value_if_false)

There are three arguments in the IF function. The first argument is any logic-

al test that results in a TRUE or FALSE. For example, you might have logic-

al tests such as these:

A2>100

B5="West"

C99<=D99

Table 12.6. Comparison Operators

The remaining two arguments are the formula or value to use if the logical

test is true and the formula or value to use if the logical test is false.