I think I need a macro, but would rather a formula

[JamesKM]

Is there a formula I can put in column F that will fill in the relevant payment stage in this example spreadsheet. The trouble I have had is that the formula needs to pick up a lot of variables, namely:
Whether the company has paid
Whether the customer has completed all payments
Whether the due date is less than today()
etc.

I hope the example below is self explanatory as to the payment stages required.

If I need to write a macro to evaluate the sheet please could you help with that (although I would prefer a formula)

Book2
	A	B	C	D	E	F	G	H	I
1	CompanyName	AmountDue	DateDue	AmountPaid	DatePaid	PaymentStage		PaymentStages	TodaysDate
2	Company1	50.00	01/10/2002	50.00	01/10/2002			AwaitingPayment	10/10/2002
3	Company1	50.00	01/11/2002					OverduePayment
4	Company1	50.00	01/12/2002					PaymentReceived(awaitingOthers)
5	Company1	50.00	01/01/2003					PaidinFull
6	Company1	50.00	01/02/2003
7	Company1	50.00	01/03/2003
8	Company2	75.00	01/10/2001	75.00	01/10/2001
9	Company2	75.00	01/12/2001	75.00	01/12/2001
10	Company2	75.00	01/01/2002	75.00	01/01/2002
11	Company2	75.00	01/02/2002	75.00	01/02/2002
12	Company2	75.00	01/03/2002	75.00	01/03/2002
13	Company2	75.00	01/04/2002	75.00	01/04/2002
14	Company3	100.00	15/11/2001	100.00	15/11/2001
15	Company3	100.00	15/12/2001	100.00	15/12/2001
16	Company3	100.00	15/01/2002	100.00	15/01/2002
17	Company3	100.00	15/02/2002	100.00	15/02/2002
18	Company3	100.00	15/03/2002	100.00	15/03/2002
19	Company3	100.00	15/04/2002	100.00	15/04/2002
20	Company3	100.00	15/05/2002	100.00	15/05/2002
21	Company3	100.00	15/06/2002	100.00	15/06/2002
22	Company3	100.00	15/07/2002	100.00	15/07/2002
23	Company3	100.00	15/08/2002	100.00	15/08/2002
24	Company3	100.00	15/09/2002	100.00	15/09/2002
25	Company3	100.00	15/10/2002
26	Company3	100.00	15/11/2002
Sheet1

[ This Message was edited by: JamesKM on 2002-10-10 10:35 ]</font>
This message was edited by JamesKM on 2002-10-10 10:56

 

[DonkeyOte]

Not entirely sure if this was what you were after (my today() is in H1)

=IF(AND(B2=D2,SUMIF($A$2:$A$13,$A2,$B$2:$B$13)>SUMIF($A$2:$A$13,$A2,$D$2:$D$13)),"Payment Received (Awaiting Others)",IF(AND(B2>D2,$H$1>$C2),"Overdue Payment",IF(B2>D2,"Not Paid","Paid in Full")))