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?
You could use a formula to multiply those February expenses by 7 percent.
So start by typing the discount rate .07 in the empty cell D9, and then type the formula in cell D4.