Autopopulate with zero

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

roy.okinawa - 13 Dec 2005 23:30 GMT

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.

Reply to this Message

Ashish Mathur - 14 Dec 2005 00:12 GMT

Dear Roy,

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

Regards,

Ashish Mathur

> 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.

Reply to this Message

roy.okinawa - 14 Dec 2005 01:00 GMT

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?

> Dear Roy,
>
[quoted text clipped - 9 lines]
> > 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.

Reply to this Message

RagDyer - 14 Dec 2005 01:11 GMT

Try this in *all* the columns necessary:

=IF(ISNUMBER(AD1),0,"")

Signature

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

> 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
[quoted text clipped - 15 lines]
> > > 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.

Reply to this Message