X hits on this document

304 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 views304
Page views304
Page last viewedTue Jan 17 13:36:54 UTC 2017
Pages65
Paragraphs433
Words3509

Comments