8 In cell G6 , enter a formula that calculates the Discount
8.000
Rate for the Off-Peak rental price per day . For example , using the peak and off-peak per day values , the studio apartment rents for 80 % of its peak rental rate . However , you need to calculate and display the off-peak discount rate , which is . 19973 .
9 Copy the formula in cell D6 to cells D7 : D8 . Copy the 4.000 formula in cell G6 to cells G7 : G8 .
10 Format the range C6 : F8 with Accounting Number 6.000
Format .
11 Format the range G6 : G8 in Percent Style with one 6.000 decimal place .
12 Apply Blue , Accent 1 , Lighter 80 % fill color to the range 4.000
E5 : G8 .