Microsoft Office Tutorials and References
In Depth Information
Displaying Values Based on a Certain Condition
NOTE: Don’t worry yet about decimal points and how to round them off; that’s covered in
Chapter
SUM
And as with
, you can always drag your mouse across an alternative range if you
don’t like the one that Excel suggests. And there’s no reason why you can’t drag across
several columns as well as down many rows. This expression is perfectly legal, then:
=AVERAGE(A12:C32)
Displaying Values Based on a Certain Condition
Again, there are a couple of hundred other functions out there for you to explore, but
we’re going to illustrate just one more. It’s called
IF
, and it carries out an action in a cell
provided another cell meets a certain condition (or conditions) that you establish.
What does that mean? Consider this simple scenario: you’re a teacher who’s given an
exam with a passing grade of 65. You want to be able to list your class scores on a
worksheet and automatically determine at a glance which students have passed.
In cell I12, enter the grade 66. OK, we know the grade is a pass, but we could be
assessing dozens, or even hundreds, of scores at the same time, where the pass/fail
evidence in every student’s case wouldn’t be quite so clear, because you might miss a
score as you visually scan a long column of scores.
Click in cell J12 and type . I know that’s a rather cryptic thing to write, but we’re =I
stopping there because you’ll notice that something is already happening on the screen,
as shown in Figure 4–13.
Figure 4–13. What starts to happen when you begin to enter the IF function (or any function)
What’s happening is that Excel already knows you’ve started to write a function. It
knows because you’ve begun the expression by typing the
sign plus a letter (in this
case I). This has triggered what’s called the Formula AutoComplete , that drop-down
menu that lists function names, narrowing down the selection as you continue to type
=

Search JabSto ::

Custom Search