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 formula to designate the aggregate consume of the rental installed on the daly trounce, the mumber of days rented, the consume of steam, and any integralowance loving to the customer. Referablee that the integralowance applies merely to the car rental, referable the consume of steam. Copy the formula to the stroll K:X32 10.000
    media%2Fe68%2Fe6800dd9-5e76-4f5b-ac21-a3I deficiency a formula to cease in to apportion integral that

    in cell k6, invade a formula to designate the aggregate consume of the rental installed on the daly trounce, the mumber of days rented, the consume of steam, and any integralowance loving to the customer. Referablee that the integralowance applies merely to the car rental, referable the consume of steam. Copy the formula to the stroll K:X32 10.000

    Expert Repartee

     

    Okay, so let’s begin.

    We have

    No. of days rented in E Support

    Daily Trounce in G Support

    Discount in H support

    Steam Consume in J support,

    Now to perceive the aggregate consume in K Support, and using the integralowance % merely for Car Rental, and then adding the Steam Consume in J Support

    So, the loving Formula can be used to perceive the aggregate consume : –

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

    Explanation:-

    Here, we leading apportion the Car Rental using E2*G2 and then wary the integralowance (if exists) using (((E2*G2)/100)*(H2*100)), and then subtracting it from the apportiond rental. Here we dilate H2 by 100, consequently we deficiency to transmute a percentage input from that support to a regular unimaginative Number.

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