andersen_yunan
New Member
- Joined
- Feb 7, 2018
- Messages
- 36
Hi All, currently I have problem to solve this issue regarding setting up formula for case below.
As you can see, I have a payment threshold of $1500, while the original data that I have is only the column #number & #payment made. I want to have a formula that can generate the value in column #payment limit & #payment excess, which the total of payment limit should not exceed given payment threshold for each number.
Is there any excel formula that can solve this?
Thanks in advance!
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
As you can see, I have a payment threshold of $1500, while the original data that I have is only the column #number & #payment made. I want to have a formula that can generate the value in column #payment limit & #payment excess, which the total of payment limit should not exceed given payment threshold for each number.
Is there any excel formula that can solve this?
Thanks in advance!
Payment Threshold: 1500 | |||
Number | Payment Made | Payment Limit | Payment Excess |
A | 1000 | 1000 | 0 |
A | 2000 | 500 | 1500 |
A | 1500 | 1500 | 0 |
B | 2000 | 1500 | 500 |
C | 3000 | 1500 | 1500 |
D | 2200 | 1500 | 700 |
E | 400 | 400 | 400 |
E | 1200 | 1100 | 100 |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>