Not sure how to format this if statement
 

I'm having difficulty forming this statement and would be grateful for
assistance.

Cell D1 contains the formula
If cell A1 is empty then cell D1 remains empty
If cell A1 contains a date and cell B1 is empty then cell D1 returns
"Outstanding"
If cell A1 contains a date and cell B1 contains text then cell D1 remains
empty
If cell A1 contains a date and cell B1 is empty and cell C1 contains a date
then cell D1 returns "Cleared"

Thank you

Not sure how to format this if statement
 

I've kept this simple by assuming:
A1 & C1 can only be empty or contain a date and any entry into B1 will only
be a comment (text)

=if(A1 =
"","",if(and(A1<"",b1="",c1=""),"Outstanding",if( and(A1<"",B1<"",C1=""),"",if(and(A1<"",B1="",C1 <""),"Cleared","ERROR!"))))

I've added the error condition in case an operator should fail to erase B1
when adding a date to C1.

HTH

Giz

"jimar" wrote:

I'm having difficulty forming this statement and would be grateful for
assistance.

Cell D1 contains the formula
If cell A1 is empty then cell D1 remains empty
If cell A1 contains a date and cell B1 is empty then cell D1 returns
"Outstanding"
If cell A1 contains a date and cell B1 contains text then cell D1 remains
empty
If cell A1 contains a date and cell B1 is empty and cell C1 contains a date
then cell D1 returns "Cleared"

Thank you

Not sure how to format this if statement
 

Thanks very much this is exactly what I needed.

"Gizmo63" wrote:

I've kept this simple by assuming:
A1 & C1 can only be empty or contain a date and any entry into B1 will only
be a comment (text)

=if(A1 =
"","",if(and(A1<"",b1="",c1=""),"Outstanding",if( and(A1<"",B1<"",C1=""),"",if(and(A1<"",B1="",C1 <""),"Cleared","ERROR!"))))

I've added the error condition in case an operator should fail to erase B1
when adding a date to C1.

HTH

Giz

"jimar" wrote:

I'm having difficulty forming this statement and would be grateful for
assistance.

Cell D1 contains the formula
If cell A1 is empty then cell D1 remains empty
If cell A1 contains a date and cell B1 is empty then cell D1 returns
"Outstanding"
If cell A1 contains a date and cell B1 contains text then cell D1 remains
empty
If cell A1 contains a date and cell B1 is empty and cell C1 contains a date
then cell D1 returns "Cleared"

Thank you