Microsoft Office Tutorials and References

In Depth Information

Create a

CONDITIONAL FORMULA

With a conditional formula, you can perform

calculations on numbers that meet a certain

condition. For example, you can find the highest score

for a particular team from a list that consists of

several teams. The Team number is the condition and

you can set the formula so only the values for players

on a particular team are evaluated.

A conditional formula uses at least two functions. The

first function,
IF
, defines the condition, or test, such

as players on Team 1. To create the condition, you

use comparison operators, such as greater than (>),

greater than or equal to (>=), less than (<), less

than or equal to (<= ), or equal to (=).

The second function in a conditional formula performs

a calculation on numbers that meet the condition.

Excel carries out the
IF
function first and then

calculates the values that meet the condition defined

in the
IF
function. Because two functions are involved,

when you use the Function Wizard, one function,
IF
,

is an argument of another function.

1

Type the data into the

worksheet.

2

Click in the cell in which you

want the results to appear.

3

3

Click the Insert Function button.

1

2

The Insert Function dialog box

appears.

l

4

Click here and select All.

5

Double-click the function on

which you want to base your

conditional function.

This example uses
MAX
, which

finds the highest value in a list.

4

5

40