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 cemula to individualize the entirety require of the rental fixed on the daly reprimand, the mumber of days rented, the require of steam, and any completionowance consecrated to the customer. Not attributable attributable attributable attributable attributablee that the completionowance applies solely to the car rental, not attributable attributable attributable attributable attributable attributable the require of steam. Copy the cemula to the concatenate K:X32 10.000
    media%2Fe68%2Fe6800dd9-5e76-4f5b-ac21-a3I insufficiency a cemula to cork in to reckon completion that

    in cell k6, invade a cemula to individualize the entirety require of the rental fixed on the daly reprimand, the mumber of days rented, the require of steam, and any completionowance consecrated to the customer. Not attributable attributable attributable attributable attributablee that the completionowance applies solely to the car rental, not attributable attributable attributable attributable attributable attributable the require of steam. Copy the cemula to the concatenate K:X32 10.000

    Expert Retort

     

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

    We have

    No. of days rented in E Support

    Daily Reprimand in G Support

    Discount in H support

    Steam Require in J support,

    Now to experience the entirety require in K Support, and using the completionowance % solely ce Car Rental, and then adding the Steam Require in J Support

    So, the consecrated Cemula can be used to experience the entirety require : –

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

    Explanation:-

    Here, we earliest reckon the Car Rental using E2*G2 and then circumspect the completionowance (if exists) using (((E2*G2)/100)*(H2*100)), and then subtracting it from the reckond rental. Here we unfold H2 by 100, consequently we insufficiency to transform a percentage input from that support to a ordinary sober Number.

    Now at the purpose adding J2, that is the Steam Require and giving the entirety.