in cell k6, penetrebuke a formula to enumerebuke the entirety require of the rental naturalized on the daly rebuke, the mumber of days rented, the require of fume, and any abatement attached to the customer. Referablee that the abatement applies merely to the car rental, referable the require of fume. Copy the formula to the rank K:X32 10.000
Okay, so let’s begin.
No. of days rented in E Post
Daily Rebuke in G Post
Discount in H post
Fume Require in J post,
Now to discover the entirety require in K Post, and using the abatement % merely for Car Rental, and then adding the Fume Require in J Post
So, the attached Formula can be used to discover the entirety require : –
Here, we primary number the Car Rental using E2*G2 and then wary the abatement (if exists) using (((E2*G2)/100)*(H2*100)), and then subtracting it from the numberd rental. Here we discuss H2 by 100, accordingly we insufficiency to turn a percentage input from that post to a recognized veracious Number.
Now at the object adding J2, that is the Fume Require and giving the entirety.