software

Columns V, X, AA, AB, and AD may have dates in them that are entered
manually. Sometimes they will be left blank.

What I need is a formula that will put a zero in columns V,X,AA, and AB when
column AD has a date entered.

Dear Roy,

Try this formula in V1 (say). If(countblank(AD1)=1,0,AD1)

Regards,

Ashish Mathur

quot;roy.okinawaquot; wrote:

gt; Columns V, X, AA, AB, and AD may have dates in them that are entered
gt; manually. Sometimes they will be left blank.
gt;
gt; What I need is a formula that will put a zero in columns V,X,AA, and AB when
gt; column AD has a date entered.

By putting that formula in V1 it gives me a date(the same date that is input
in AD1.) It should be a zero. It will not let me format the cell to accept a
zero either.

Also, will a formula like this need to be input in each column V, X, AA, AB?

quot;Ashish Mathurquot; wrote:

gt; Dear Roy,
gt;
gt; Try this formula in V1 (say). If(countblank(AD1)=1,0,AD1)
gt;
gt; Regards,
gt;
gt; Ashish Mathur
gt;
gt; quot;roy.okinawaquot; wrote:
gt;
gt; gt; Columns V, X, AA, AB, and AD may have dates in them that are entered
gt; gt; manually. Sometimes they will be left blank.
gt; gt;
gt; gt; What I need is a formula that will put a zero in columns V,X,AA, and AB when
gt; gt; column AD has a date entered.

Try this in *all* the columns necessary:

=IF(ISNUMBER(AD1),0,quot;quot;)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;roy.okinawaquot; gt; wrote in message
...
gt; By putting that formula in V1 it gives me a date(the same date that is
input
gt; in AD1.) It should be a zero. It will not let me format the cell to
accept a
gt; zero either.
gt;
gt; Also, will a formula like this need to be input in each column V, X, AA,
AB?
gt;
gt; quot;Ashish Mathurquot; wrote:
gt;
gt; gt; Dear Roy,
gt; gt;
gt; gt; Try this formula in V1 (say). If(countblank(AD1)=1,0,AD1)
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Ashish Mathur
gt; gt;
gt; gt; quot;roy.okinawaquot; wrote:
gt; gt;
gt; gt; gt; Columns V, X, AA, AB, and AD may have dates in them that are entered
gt; gt; gt; manually. Sometimes they will be left blank.
gt; gt; gt;
gt; gt; gt; What I need is a formula that will put a zero in columns V,X,AA, and
AB when
gt; gt; gt; column AD has a date entered.