Excel nested IF

I need to create an IF formula based on data in 3 different columns and give a result of yes or no if certain conditions are met as follows:

If D2 = "Achieved" and  E2 = "NO"    then J2 = "YES"
If E2 = "Expires"  and  I2 > TODAY() then J2 = "YES"
If E2 = "Expires"  and  I2 < TODAY() then J2 = "NO"
If I2 = "Never Achieved"             then J2 = "NO"

I've tried various combinations of IFs and ANDs and I'm going round in circles at this point. Any help appreciated!