How can I join the following two If statements together?

[Daniel_21]

Hi,

I need to merge the following two statements and I'm not sure how to merge them for them to work?

=IF(E288="","Incomplete",IF(OR(E288<D288,E288=D288),"Completed",IF(E288>D288,"Cmp Late")))

=IF(C288>E288,"Early","Cmp or late")

any if statement genius?

 

[jproffer]

I'm not sure where all your dates are, so I'll do this rather generically....so here goes...adjust as needed.

A1 is completed date, A2 is "on time" date

=IF(A1="","Incomplete",IF(A1<A2,"Complete, early",IF(A1=A2, "Complete, on time",IF(A1>A2, "Complete, but late"))))

That was made on the fly without excel available, but I think I got all the ")" in there

EDITED ABOVE a few minutes after original post....