Hello,
I am trying to create a formula that will do;
If C2 AND D2 AND E2 contain text (date format) then "READY" else "BLANK" in another cell.
If any of the three cells have a date it still needs to show blank, only when all three have a date can it show ready.
I have tried various If statements using IS BLANK and <> and cannot get it right. Does anyone know a formula that will do this?
I am trying to create a formula that will do;
If C2 AND D2 AND E2 contain text (date format) then "READY" else "BLANK" in another cell.
If any of the three cells have a date it still needs to show blank, only when all three have a date can it show ready.
I have tried various If statements using IS BLANK and <> and cannot get it right. Does anyone know a formula that will do this?