Afternoon,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
></o
>
This one has been giving me nightmares, (Literary) all month.<o
></o
>
<o
></o
>
It is an IF statement which users ranges and arguments. I have similar, which works without problems. <o
></o
>
<o
></o
>
My main problem is that the arguments are not working in sequence. <o
></o
>
<o
></o
>
Any help would be fantastic.<o
></o
>
<o
></o
>
=<o
></o
>
IF(AND(OR(Item="X", Item="Y"),GOS="Failed",FAULTFail=""),"Failure",<o
></o
>
IF(AND(OR(Item="X", Item="Y"),GOS ="Incomplete",FAULTFail="", FaultDueDate<=TODAY()),"2. PM Must confirm Actual Date",<o
></o
>
IF(AND(OR(Item="X", Item="Y"),GOS ="Complete"),"7.Pass",<o
></o
>
IF(AND(OR(Item="X", Item="Y"),GOS ="Successful"),"7.Pass",<o
></o
>
IF(OR(Item<>"X", Item<>"Y, GType<>""),"8.Standard NA",<o
></o
>
IF(FaultDueDate=TODAY(),"3.Standard Due Today",<o
></o
>
IF(FaultDueDate<=TODAY()+3,"4.Three Days Warning",<o
></o
>
IF(FaultDueDate<=TODAY()+10,"5.Ten Day Plus",<o
></o
>
IF(FaultDueDate<=TODAY()+15,"6.Fifteen Day Plus",<o
></o
>
"9. Greater than Fifteen Days till standard")))))))))<o
></o
>
<o
> </o
>
By my thinking, if all of the first 5 Ifs are “False”, then it should move to 6, then 7 and so on. but it seems to jump to 7?
L<o
></o
>
<o
> </o
>




<o


This one has been giving me nightmares, (Literary) all month.<o


<o


It is an IF statement which users ranges and arguments. I have similar, which works without problems. <o


<o


My main problem is that the arguments are not working in sequence. <o


<o


Any help would be fantastic.<o


<o


=<o


IF(AND(OR(Item="X", Item="Y"),GOS="Failed",FAULTFail=""),"Failure",<o


IF(AND(OR(Item="X", Item="Y"),GOS ="Incomplete",FAULTFail="", FaultDueDate<=TODAY()),"2. PM Must confirm Actual Date",<o


IF(AND(OR(Item="X", Item="Y"),GOS ="Complete"),"7.Pass",<o


IF(AND(OR(Item="X", Item="Y"),GOS ="Successful"),"7.Pass",<o


IF(OR(Item<>"X", Item<>"Y, GType<>""),"8.Standard NA",<o


IF(FaultDueDate=TODAY(),"3.Standard Due Today",<o


IF(FaultDueDate<=TODAY()+3,"4.Three Days Warning",<o


IF(FaultDueDate<=TODAY()+10,"5.Ten Day Plus",<o


IF(FaultDueDate<=TODAY()+15,"6.Fifteen Day Plus",<o


"9. Greater than Fifteen Days till standard")))))))))<o


<o


By my thinking, if all of the first 5 Ifs are “False”, then it should move to 6, then 7 and so on. but it seems to jump to 7?
L<o


<o

