July 17, 2018
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?
April 21, 2015