X hits on this document

272 views

0 shares

0 downloads

0 comments

38 / 65

Enter formulas

Using an absolute cell reference

Say you receive some entertainment coupons offering a 7 percent discount for video rentals, movies, and CDs. How much could you save in a month by using the discounts?

Cell D9 contains the value for the 7 percent discount.

You can copy the formula from cell D4 to D5 by using the fill handle. As the formula is copied, the relative cell reference changes from C4 to C5, while the absolute reference to the discount in D9 does not change; it remains as $D$9 in each row it is copied to.

Document info
Document views272
Page views272
Page last viewedThu Dec 08 18:31:26 UTC 2016
Pages65
Paragraphs433
Words3509

Comments