Nested If issue dealing with empty cells--help needed!|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi All I wonder if anyone could assist.

I have a formula in Colum H “Assets in Production” on the manager worksheet that returns one of two values “Outstanding” or “Completed” based on two conditions or should display nothing if both cells are blank.

• If Colum D “Assets in Production” and Colum G “Actual Sign off Requested Date” both contain a date value then “Completed” should be displayed in Column H.
• If there is just a date in Colum D but not date in Colum G then “Outstanding” should be displayed in Colum H.
• If both Colum D & G are blank then nothing should be displayed in Column H.

It’s the last part that I can’t get to work.

This is the formula I’m trying & I’m sure it’s close but something isn’t working can anybody suggest a solution?

IF(AND(D2<>"",G2<>""),"Completed", IF((AND(D2="",G2="",),"","Outstanding")))