Debtors ageing

[McQLon]

Hi,

I need help ageing a debtors spreadsheet. I want column H in the attached sheet to say whether something is "Current", "Up to 30 days overdue", "Up to 60 days overdue" and "More than 60 days overdue".

Please help. There is further narrative on the attached sheet.


Thanks.

[brokenbiscuits]

=IF(G4<=0,"Current",IF(G4<=30,"Up to 30 days",IF(G4<=60,"Up to 60 days","More than 60 days")))

[McQLon]

How easy was that! Thanks for helping, i'm clearly not with it today.