Microsoft Office Tutorials and References
In Depth Information
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.
Type the data into the
Click in the cell in which you
want the results to appear.
Click the Insert Function button.
The Insert Function dialog box
Click here and select All.
Double-click the function on
which you want to base your
This example uses MAX , which
finds the highest value in a list.