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.

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

"Dahlman" wrote:

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.

Thank you very much. That worked.

"Jane" wrote:

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

"Dahlman" wrote:

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.