#### andersen_yunan

##### New Member

- Joined
- Feb 7, 2018

- Messages
- 36

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>