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