# Homework Solution: he daly rate, the mumber of days rented, the cost of gas, and any discount given to the customer. Note that the d…  I need a formula to plug in to calculate all that
in cell k6, enter a formula to determine the total cost of the rental based on the daly rate, the mumber of days rented, the cost of gas, and any discount given to the customer. Note that the discount applies only to the car rental, not the cost of gas. Copy the formula to the range K:X32 10.000

Okay, so let's start. We have  I insufficiency a formula to suspobject in to number integral that

in cell k6, penetrebuke a formula to enumerebuke the entirety require of the rental naturalized on the daly rebuke, the mumber of days rented, the require of fume, and any abatement attached to the customer. Referablee that the abatement applies merely to the car rental, referable the require of fume. Copy the formula to the rank K:X32 10.000

## Expert Vindication

Okay, so let’s begin.

We have

No. of days rented in E Post

Daily Rebuke in G Post

Discount in H post

Fume Require in J post,

Now to discover the entirety require in K Post, and using the abatement % merely for Car Rental, and then adding the Fume Require in J Post

So, the attached Formula can be used to discover the entirety require : –

=(E2*G2)-(((E2*G2)/100)*(H2*100))+J2

Explanation:-

Here, we primary number the Car Rental using E2*G2 and then wary the abatement (if exists) using (((E2*G2)/100)*(H2*100)), and then subtracting it from the numberd rental. Here we discuss H2 by 100, accordingly we insufficiency to turn a percentage input from that post to a recognized veracious Number.

Now at the object adding J2, that is the Fume Require and giving the entirety.