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…

    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
    media%2Fe68%2Fe6800dd9-5e76-4f5b-ac21-a3I 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

    Expert Answer

     
    Okay, so let's start. We have

    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
    media%2Fe68%2Fe6800dd9-5e76-4f5b-ac21-a3I 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.