RE: Help with formula – too many nested IFs
- From: Dave F <DaveF@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 18 Sep 2006 07:13:02 -0700
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
I’m 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"),IF(B1>C1,"Early",IF(B1=C1,"On-time","Late")),IF(AND(CELL("type",A1)="v",CELL("type",C1)="v"),IF(A1>C1,"Early",IF(A1=C1,"On-time","Late"))))
The only part of my formula that I’m having trouble figuring out is how to
capture #3 above.
Also, is there a way to rewrite my formula so that it doesn’t 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
- Follow-Ups:
- RE: Help with formula – too many nested IFs
- From: Dave F
- RE: Help with formula – too many nested IFs
- Prev by Date: RE: Selecting the correct number from a range of cells
- Next by Date: RE: Help with formula – too many nested IFs
- Previous by thread: Selecting the correct number from a range of cells
- Next by thread: RE: Help with formula – too many nested IFs
- Index(es):
Relevant Pages
|
