Payout calculation

[chaharmumesh]

Hi All,

I have data in which there some customer who had bought some oil in 3 different pack sizes 7.5 L , 10 L and 15 L and in the Picture file attached i have given the number of bucket purchased for each pack size. Now i want Give Payout in such a way that for Every 5 Buckets ,customers is given INR 6/L. The Order of buckets should be like first 15 Liters buckets to be used than 10L and then 7.5

Thanks in advance

 

[chaharmumesh]

oh yes

and assume you already have this, but this is in f2

=SUM(C2:E2)

Dave

Thanks its working perfectly fine , just a small addition i have done that it is giving 6 RS/ltr even a customer a bought a one bucket , ideally it should give on minimum 5 buckets. but no worries i have added if condition.

 

[chaharmumesh]

Now there is twist to this question , if the 15 L buckets is no longer there ,only 7.5 L and 10 L buckets is there and the schemes has changed to every 8 buckets 6 Rs /ltr to be given. attached the data sample. The order of the Payout is like first all the buckets of 10 litres is to be used and then 7.5 Litres buckets.

Again thanks in advance