Condition for Payment
1) A person need to sell targeted item to get payment.
2) We can adjust excess items sold for day where the person hasn't completed the target.
3) We need to adjust first in upper cells and only after all previous days are adjusted only than we can adjust the remaining part, if any to the downward days.
Question
Target Sell Actual Sold Wheter Amt Payble for the Day
Day - 1 2 1
Day - 2 2 3
Day - 3 2 0
Day - 4 2 0
Day - 5 2 5 ex...we can adjust this 5 (first in cells above and if all days are adjusted and we have something remaing only then cells below will be adjusted.
Day - 6 2 0
Day - 7 3 0
Day - 8 3 5
Day - 9 3 1
Day - 10 3 0
Day - 11 3 0
Day - 12 3 4
i need a formula that can calculate which days are qualified for payment
Bookmarks