Prev: Call Macro
Next: In creating a COUNTIF and a COUNT to show as ie 4of10?
From: tommy touareg tommy on 21 Feb 2010 11:33
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
From: Fred Smith on 21 Feb 2010 12:28
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.

Regards,
Fred

"tommy touareg" <tommy touareg(a)discussions.microsoft.com> wrote in message
news:1AC5D321-5FF4-46B2-9CC7-BC86EFD3DD67(a)microsoft.com...
>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

 | 
Pages: 1
Prev: Call Macro
Next: In creating a COUNTIF and a COUNT to show as ie 4of10?