Easy function question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have 3 columns. the first column is a Scheduled Date and the 2nd column is
an actual ship date. I want my 3rd column to gime a "Yes" if it is on time
and a "NO" if it isn't on time. Now I know how to make that IF statement but
I also want to copy the formula down about 25 rows in which I don't have any
dates in. As a default it show's all Yes's if there arent' any dates. I would
like my 3rd column to figure yes but if column 1 has no date I don 't want it
to show anything, and if column 1 does have a date but column 2 doesn't have
anything then I was column 3 to display "Not Completed". If this isn't clear
what I'm asking for then please respond and I'll try to clarify better.
thanks in advance for your help.
.

Relevant Pages

  • Re: AD & DNS
    ... Sounds like somebody's simply added another connection to the same Domain ... You can just delete this from the display. ... You can clarify whether ... Prev by Date: ...
    (microsoft.public.windows.server.active_directory)
  • Re: Displaying table contents on a from
    ... On the standard toolbar at the top of the screen, ... table you want to display, click Next, then if you want just some of the ... Press book "Microsoft Access ... I suspect you'll have to clarify what you want for anyone to be able to ...
    (comp.databases.ms-access)
  • Re: frontpage-red x
    ... Let me clarify the problem. ... able to recreate or view the problem myself. ... At home and work all navigations ... buttons are either display as a red X or don’t work when click on. ...
    (microsoft.public.frontpage.client)
  • Re: Testing in a restaurant
    ... > no one especially madison was even hinting that someone testing or ... > injecting in public should make a display of it. ... to clarify things. ...
    (alt.support.diabetes)
  • Re: Email Display Name As
    ... To clarify your post you will need to explain where it is you want to change ... > Using 2003 with BCM V2... ... > Sometimes I have the hardest time changing an email so that it displays ... > Sometimes the Display as has the person name from the contact field, ...
    (microsoft.public.outlook)