I am trying to nest several (7), IF/AND statements into a cell. My goal is to use my clients last payment date (A2) to produce an aging accounts dues column (D2).
IF A2 is <= 275, "Current"
IF A2 is > 305, But <=335, "Due in 60 Days"
IF A2 is > 335, But <=365, "Due in 30 Days"
IF A2 is > 395, But <=425, "30 days Past Due"
IF A2 is > 425, But <=455, "60 days Past Due"
IF A2 is > 455, But <=485, "90 days Past Due"
IF A2 is > 515, "120+ days Past Due"
While this feels like a simple IF AND combination, I am have difficulty getting it to work correctly.
Thanks.
Eric
Bookmarks