LutonBarry
03-17-2016, 07:17 AM
Folks I have the attached spreadsheet and where it returns FALSE in Col D I would like it to return an empty cell.
I'm in brain fade mode, the formula =IFERROR(A2="Resolved",IF(OR(ISBLANK(B2),ISBLANK(C2)),"Not Complete","")) does what I want it to i.e. If the Ticket Status in Col A is Resolved and Cols B and C are not blank it returns an empty cell, but it either Cols B or C are are Blank it returns 'Not Complete'. It's the False statement for cells in Column A that are not labelled as 'Resolved'.
I'm in brain fade mode, the formula =IFERROR(A2="Resolved",IF(OR(ISBLANK(B2),ISBLANK(C2)),"Not Complete","")) does what I want it to i.e. If the Ticket Status in Col A is Resolved and Cols B and C are not blank it returns an empty cell, but it either Cols B or C are are Blank it returns 'Not Complete'. It's the False statement for cells in Column A that are not labelled as 'Resolved'.