Easy function question

[Guest]

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.

 

[Guest]

Try adding this before the formula you already have, with two extra ) at the
end:

=IF(A1="","",IF(B1="","NOT COMPLETED",IF(

Hope this helps.

Jane

 

[Guest]

Thank you very much. That worked.

Try adding this before the formula you already have, with two extra ) at the
end:

=IF(A1="","",IF(B1="","NOT COMPLETED",IF(

Hope this helps.

Jane