Microsoft Office Tutorials and References
In Depth Information
Copying Formulas: More Than Just Duplication
What Excel won’t do, then, is take the 60 and multiply it by 3 – 2, yielding 60. Play
around with some of your own examples and the order of operations will become
clearer.
Copying Formulas: More Than Just Duplication
I’ve already discussed how to copy data and formats through the format painter. But
copying formulas introduces something new, something important. Let’s see what that
means.
1.
Enter the test data shown
in Figure 4–20 in a blank
spreadsheet, starting at
cell J7.
Figure 4–20. Tough test
2.
Save the file under the name Student Scores.
3. Now let’s say that, because the scores are on the low side (these could
be scores relative to a test score maximum of say, 120, but it doesn’t
much matter), the teacher decides to award a five-point bonus—and as
a result, needs to write a formula that will impart that bonus to all the
students. Enter the word Bonus to serve as a heading in cell L7, and in
L8, write
=K8+5
That little formula delivers a score of 82 to John, boosting his original 77. The question is
how to award the same bonus to all the students, along with the implied question of
what would happen if the class consisted of 100 students instead of just the five in our
example.
The one thing the teacher won’t do is write the formula for each student—that’s way too
inconvenient. The alternative is to copy the original formula down the L column, but we
need to describe how that works.
There are several ways to copy a formula; we’ll look at two of them. The first is very
similar to the technique discussed in Chapter 2.
 
Search JabSto ::




Custom Search