Change what I give below to this:

=IF(NOT(OR(ISBLANK(B1),ISBLANK(C1))),[calculate delivery
performance],IF(NOT(OR(ISBLANK(A1),ISBLANK(B1))),[calculate delivery
performance],"Missing dates")

This assumes, of course, that if A1, B1, or C1 do not have dates in them,
they also have nothing else in them. If that's not the case, then you have
to test for the presence of data formatted as dates.

Dave
--
Brevity is the soul of wit.


"Dave F" wrote:

I guess I would do something like
=IF(NOT(OR(ISBLANK(B1),ISBLANK(C1))),[calculate delivery
performance,IF(NOT(OR(ISBLANK(A1),ISBLANK(B1))),[calculate delivery
performance],"")

This seems rather complicated though. Perhaps you can split these
IF-THEN-ELSE constructions into multiple logic statements, make sure that
each is operating correctly, and then combine all of them into one giant
formula?

What I put above says, in plain English, "IF neither B1 nor C1 is blank,
then calculate performance, ELSE IF neither A1 nor B1 is blank, THEN
calculate performance, ELSE nothing."

Dave
--
Brevity is the soul of wit.


"Bob" wrote:

Dave,
You're right! Thanks for catching my error.
Can you help me modify my formula to incorporate the 3rd step and/or rewrite
it so that it doesn't include so many nested IFs?
Bob


"Dave F" wrote:

Based on steps 1 and 2, your 3rd step should have the logic (A1 OR B1) AND
C1, not the way you have it, which is A1 AND B1 OR C1.

Dave

--
Brevity is the soul of wit.


"Bob" wrote:

A1 = Original Planned Due Date
B1 = Revised Planned Due Date
C1 = Actual Due Date

Im trying to write a formula that computes the following:

1) If dates exist in cells B1 AND C1, calculate delivery performance (i.e.,
Eary, On-time, or Late) in cell D1

ELSE

2) If dates exist in cells A1 AND C1, calculate delivery performance in cell
D1

ELSE

3) If there are no dates in ((A1 AND B1) OR C1), display €œMissing date(s)€�
in cell D1

The formula I have written so far is:
=IF(AND(CELL("type",B1)="v",CELL("type",C1)="v"),I F(B1C1,"Early",IF(B1=C1,"On-time","Late")),IF(AND(CELL("type",A1)="v",CELL("ty pe",C1)="v"),IF(A1C1,"Early",IF(A1=C1,"On-time","Late"))))

The only part of my formula that Im having trouble figuring out is how to
capture #3 above.

Also, is there a way to rewrite my formula so that it doesnt use so many
nested IF statements? Is there a different Excel built-in function that I
can use to streamline my formula?

Any help would be greatly appreciated.
Thanks,
Bob