software

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
quot;Outstandingquot;
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 quot;Clearedquot;

Thank you

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

=if(A1 =
quot;quot;,quot;quot;,if(and(A1lt;gt;quot;quot;,b1=quot;quot;,c1=quot;quot;),quot;Outstandingquot;,if( and(A1lt;gt;quot;quot;,B1lt;gt;quot;quot;,C1=quot;quot;),quot;quot;,if(and(A1lt;gt;quot;quot;,B1=quot;quot;,C1 lt;gt;quot;quot;),quot;Clearedquot;,quot;ERROR!quot;))))

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

HTH

Giz

quot;jimarquot; wrote:

gt; I'm having difficulty forming this statement and would be grateful for
gt; assistance.
gt;
gt; Cell D1 contains the formula
gt; If cell A1 is empty then cell D1 remains empty
gt; If cell A1 contains a date and cell B1 is empty then cell D1 returns
gt; quot;Outstandingquot;
gt; If cell A1 contains a date and cell B1 contains text then cell D1 remains
gt; empty
gt; If cell A1 contains a date and cell B1 is empty and cell C1 contains a date
gt; then cell D1 returns quot;Clearedquot;
gt;
gt; Thank you

Thanks very much this is exactly what I needed.

quot;Gizmo63quot; wrote:

gt; I've kept this simple by assuming:
gt; A1 amp; C1 can only be empty or contain a date and any entry into B1 will only
gt; be a comment (text)
gt;
gt; =if(A1 =
gt; quot;quot;,quot;quot;,if(and(A1lt;gt;quot;quot;,b1=quot;quot;,c1=quot;quot;),quot;Outstandingquot;,if( and(A1lt;gt;quot;quot;,B1lt;gt;quot;quot;,C1=quot;quot;),quot;quot;,if(and(A1lt;gt;quot;quot;,B1=quot;quot;,C1 lt;gt;quot;quot;),quot;Clearedquot;,quot;ERROR!quot;))))
gt;
gt; I've added the error condition in case an operator should fail to erase B1
gt; when adding a date to C1.
gt;
gt; HTH
gt;
gt; Giz
gt;
gt; quot;jimarquot; wrote:
gt;
gt; gt; I'm having difficulty forming this statement and would be grateful for
gt; gt; assistance.
gt; gt;
gt; gt; Cell D1 contains the formula
gt; gt; If cell A1 is empty then cell D1 remains empty
gt; gt; If cell A1 contains a date and cell B1 is empty then cell D1 returns
gt; gt; quot;Outstandingquot;
gt; gt; If cell A1 contains a date and cell B1 contains text then cell D1 remains
gt; gt; empty
gt; gt; If cell A1 contains a date and cell B1 is empty and cell C1 contains a date
gt; gt; then cell D1 returns quot;Clearedquot;
gt; gt;
gt; gt; Thank you