Excell formula


tommy touareg

I need a formula to calculate arrears payments on a spreadsheet
The sheet has a target payment for collection each week a payment column and
a remaining balance column weeks 1 to 52
I want the formula to count all arrears that are unpaid as a running total
can anyone help

Fred Smith

What's the definition of "arrears"? Does it depend on today's date, or some
other date, or something else?

Define arrears, and where it can be found, and we can help you come up with
the formula.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question