I keep getting the "Too Many Arguments" notice for this equation and I'm wondering if anyone out there can come up with A) either the proper formula; or B) a better way to do it.
I have this form that is used in production. The guys filling it out put in the criteria and the form is supposed to tell them if it's acceptable or not acceptable.
I've attached a sample with any sensitive material removed.
Essentially, what should happen is:
If cells H, I, J, K, or L are greater than cell E but less than cell D, cell O should mark with an "X" for acceptable.
If any of those cells do not fall within the limits of cells E and D, cell P should mark with an "X" for not acceptable.
The problem with my formula is that it's requiring cell H:L to fall within the limits for the "X" to mark acceptable when in reality if only cell H is filled in (as long as it's within limit), the form should be marked acceptable.
I've thought about switching the formula so that instead of having two separate formulas for cells O(acceptable) and P(not acceptable), we have one field where the value if true would mark Acceptable and the value if false would mark Not Acceptable...but i'm still having trouble working that logic...
Here are my formulas as they stand:
For cell O (Acceptable):
=IF(D4>0,"",IF(E4="","",IF(AND(D4>=0,E4>=0,H4<=D4,H4>=E4,I4<=D4,I4>=E4,J4<=D4,J4>=E4,K4<=D4,K4>=E4,L4<=D4,L4>=E4),"X","")))
For cell P (Not Acceptable):
=IF(OR(AND(H4>0,OR(H4<E4,H4>D4)),AND(I4>0,OR(I4<E4,I4>D4)),AND(J4>0,OR(J4<E4,J4>D4)),AND(K4>0,OR(K4<E4,K4>D4))),"X","")
Bookmarks