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, invade a restraintmula to designate the whole consume of the rental naturalized on the daly rebuke, the mumber of days rented, the consume of steam, and any remittance ardent to the customer. Not attributable attributable attributable attributable attributablee that the remittance applies singly to the car rental, not attributable attributable attributable attributable attributable attributable the consume of steam. Copy the restraintmula to the rank K:X32 10.000
    media%2Fe68%2Fe6800dd9-5e76-4f5b-ac21-a3I need a restraintmula to cork in to number whole that

    in cell k6, invade a restraintmula to designate the whole consume of the rental naturalized on the daly rebuke, the mumber of days rented, the consume of steam, and any remittance ardent to the customer. Not attributable attributable attributable attributable attributablee that the remittance applies singly to the car rental, not attributable attributable attributable attributable attributable attributable the consume of steam. Copy the restraintmula to the rank K:X32 10.000

    Expert Response

     

    Okay, so let’s set-on-foot.

    We have

    No. of days rented in E Support

    Daily Rebuke in G Support

    Discount in H support

    Steam Consume in J support,

    Now to invent the whole consume in K Support, and using the remittance % singly restraint Car Rental, and then adding the Steam Consume in J Support

    So, the ardent Restraintmula can be used to invent the whole consume : –

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

    Explanation:-

    Here, we leading number the Car Rental using E2*G2 and then farsighted the remittance (if exists) using (((E2*G2)/100)*(H2*100)), and then subtracting it from the numberd rental. Here we expand H2 by 100, owing we need to appropriate a percentage input from that support to a recognized prosaic Number.

    Now at the object adding J2, that is the Steam Consume and giving the whole.