Answer:
The required formula to get the value of the cell K6 i.e., total cost of the rental based on the daily rate, cost of gas, amount of discount, and number of days rented can be given as follows:
K6 =E6*G6*(1-H6)-J6
Explanation:
In the above formula, the value of the cell E6 (#Days rented) is being multiplied with the cell G6 (Daily rate), amount of discount (H6) subtracted from 1 and subtract the cell value J6 (Cost of gas) from the resulted value of the expression E6*G6*(1-H6).
Copy the above formula to the range K7:K32 to fill all the values. The resulted excel sheet will be shown as follows:
