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
Okay, so let’s set-on-foot.
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 : –
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.