IF Formula

[SaraWitch]

Hi peeps,

I have a formula in I10 based on dates in columns G and H, which works:

=IF($G10="","",IF($H10<>"","Complete",IF(ISBLANK($H10),IF(TODAY()<$G10,"Not Due",IF(TODAY()=$G10,"Due",IF(EDATE(TODAY(),-3)<$G10,"Overdue 0-3 months",IF(EDATE(TODAY(),-6)<$G10,"Overdue 4-6 months",IF(EDATE(TODAY(),-12)<$G10,"Overdue 7-12 months",""))))))))

However, I want to add another layer for I10 to be blank if J10 contains 'Yes'; but this is not working:

=IF($G10="","",IF($H10<>"","Complete",IF(ISBLANK($H10),IF(TODAY()<$G10,"Not Due",IF(TODAY()=$G10,"Due",IF(EDATE(TODAY(),-3)<$G10,"Overdue 0-3 months",IF(EDATE(TODAY(),-6)<$G10,"Overdue 4-6 months",IF(EDATE(TODAY(),-12)<$G10,"Overdue 7-12 months",IF($J10="Yes","","")))))))))

Any help would be appreciated...

 

[SaraWitch]

Ha! Just figured it out! I needed to put the J10 element at the beginning, which works:

=IF($J10="Yes","",IF($G10="","",IF($H10<>"","Complete",IF(ISBLANK($H10),IF(TODAY()<$G10,"Not Due",IF(TODAY()=$G10,"Due",IF(EDATE(TODAY(),-3)<$G10,"Overdue 0-3 months",IF(EDATE(TODAY(),-6)<$G10,"Overdue 4-6 months",IF(EDATE(TODAY(),-12)<$G10,"Overdue 7-12 months","")))))))))