Sticky If statments

craig80

Board Regular
Joined
May 18, 2010
Messages
51
Afternoon,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
This one has been giving me nightmares, (Literary) all month.<o:p></o:p>
<o:p></o:p>
It is an IF statement which users ranges and arguments. I have similar, which works without problems. <o:p></o:p>
<o:p></o:p>
My main problem is that the arguments are not working in sequence. <o:p></o:p>
<o:p></o:p>
Any help would be fantastic.<o:p></o:p>
<o:p></o:p>
=<o:p></o:p>
IF(AND(OR(Item="X", Item="Y"),GOS="Failed",FAULTFail=""),"Failure",<o:p></o:p>
IF(AND(OR(Item="X", Item="Y"),GOS ="Incomplete",FAULTFail="", FaultDueDate<=TODAY()),"2. PM Must confirm Actual Date",<o:p></o:p>
IF(AND(OR(Item="X", Item="Y"),GOS ="Complete"),"7.Pass",<o:p></o:p>
IF(AND(OR(Item="X", Item="Y"),GOS ="Successful"),"7.Pass",<o:p></o:p>
IF(OR(Item<>"X", Item<>"Y, GType<>""),"8.Standard NA",<o:p></o:p>
IF(FaultDueDate=TODAY(),"3.Standard Due Today",<o:p></o:p>
IF(FaultDueDate<=TODAY()+3,"4.Three Days Warning",<o:p></o:p>
IF(FaultDueDate<=TODAY()+10,"5.Ten Day Plus",<o:p></o:p>
IF(FaultDueDate<=TODAY()+15,"6.Fifteen Day Plus",<o:p></o:p>
"9. Greater than Fifteen Days till standard")))))))))<o:p></o:p>
<o:p> </o:p>
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:p></o:p>
<o:p> </o:p>
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Nope, defiantly a date field.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
Thanks<o:p></o:p>
Craig<o:p></o:p>
 
Upvote 0
Have you tried using the Evaluate Formula tool under Tools, Formula Auditing? That will let you see how it is evaluating each part of the IF.

Also when you have a set of values which you believe should use the 6th IF, try entering = FaultDueDate = Today() and see if it evaluates to TRUE.
 
Upvote 0

Forum statistics

Threads
1,226,730
Messages
6,192,708
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top