A B C D E F G H
N/A N/A 28-Aug-09 ? ? 200 03-Jul-09 200



=IF(A2=N/A, Lookup - B2

=IF(B2=N/A, Lookup - G2

D2=IF(G2>=NOW()-8,"Default","PAID")

=IF(D2=PAID then LOOKUP H2

If H2<F2 then E2 reads UNDER

=IF(H2>=F2,"UNDER","")

i hope you can understand what it is im trying to say -

your help would be much appreciated


Thanx

Lorna