Re: Autopopulate with zero

Tech-Archive recommends: Fix windows errors by optimizing your registry

Try this in *all* the columns necessary:

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

--
HTH,

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


"roy.okinawa" <royokinawa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B03D43F1-0AAA-46D5-A85E-4CDFC995A2DE@xxxxxxxxxxxxxxxx
> 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?
>
> "Ashish Mathur" wrote:
>
> > Dear Roy,
> >
> > Try this formula in V1 (say). If(countblank(AD1)=1,0,AD1)
> >
> > Regards,
> >
> > Ashish Mathur
> >
> > "roy.okinawa" wrote:
> >
> > > 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.

.

Relevant Pages

  • Re: how to reference a field in a table in code
    ... By the way, it is zero based! ... HTH ... RuralGuy ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Re: coditional formatting
    ... > Forgot about the zero also returning false, ... >> HTH, ... >> Please keep all correspondence within the NewsGroup, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Zero values in formula
    ... HTH, ... Please keep all correspondence within the Group, ... > My formula is A1/A2 however if they are both Zero values it is producing ... > Zero in A3? ...
    (microsoft.public.excel.misc)
  • Re: Countif function
    ... brackets, ... HTH, ... Please keep all correspondence within the Group, ... > where only values other than zero are counted in the divisor. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: if cell = 0 then hide the row?
    ... HTH ... Bob Phillips ... > Highlight this column and select Data | Filter | Autofilter. ... All your rows with zero in column F will ...
    (microsoft.public.excel.misc)