# Payment Calculation

1. ## Payment Calculation

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

2. ## Re: Payment Calculation

You need to provide sample answers so we can see what you want, but see if this is heading in the right direction...
F5=SUM(\$E\$5:E5)-SUM(\$D\$5:D5)
copied down

3. ## Re: Payment Calculation

I have put my question in more elaborated way. plz look once more the excel file.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1