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