HELP with IS BLANK statements

MLaw2023

New Member
Joined
Aug 6, 2019
Messages
2
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?
 

tyija1995

Well-known Member
Joined
Feb 26, 2019
Messages
648
Hey how about:

Code:
IF(AND(C2<>"",D2<>"",E2<>""),"READY","BLANK")
 

Forum statistics

Threads
1,085,838
Messages
5,386,254
Members
401,988
Latest member
Sherzodom

Some videos you may like

This Week's Hot Topics

Top