Nested if statements with AND and OR statements

[joeljoel]

=IF(G4="H",AI3,IF(OR(AND(D4="JAN",G4>=20),AND(D4="FEB",G4<=11),AND(D4="FEB",G4>=20),AND(D4="APR",G4<=4),AND(D4="OCT",G4>=7),AND(D4="JAN",G4<=4),D4="MAR",D4="NOV",D4="DEC"),1,IF(AND(D4=”JUN”,G4>=3),AND(D4=”JUN”,G4<=18),AND(D4=”SEP”,G4>=8),AND(D4=”OCT”,G4<=6),0)))

I keep getting the "too many arguments" error when I try to enter the above formula. Maybe I am overtired, but I cannot figure out what the heck I am screwing up here. Can anyone fix this and explain what the issue is - so I can learn this hopefully not have continued problems.

Thank you!

[DonkeyOte]

Without looking in great detail I suspect you are missing an OR prior to your second batch of AND tests.

Also, you've also not specified what the result should be if neither 1 nor 0 (presently the formula would return FALSE which coerced = 0 ... i.e. I suspect you do not want that result)

[joeljoel]

You were right about the "OR" - so I have fixed it
=IF(G4="H",AI3,IF(OR(AND(D4="JAN",G4>=20),AND(D4="FEB",G4<=11),AND(D4="FEB",G4>=20),AND(D4="APR",G4<=4),AND(D4="OCT",G4>=7),AND(D4="JAN",G4<=4),D4="MAR",D4="NOV",D4="DEC"),1,IF(OR(AND(D4=”JUN”,G4>=3),AND (D4=”JUN”,G4<=18),AND(D4=”SEP”,G4>=8),AND(D4=”OCT”,G4<=6)),-1,0)))

I still get a general error though. What I am looking for is if any of the conditions or pairs of conditions (essentially testing if the workday occurs between several pairs of two dates) occur in the first OR statement, return a 1. Otherwise, are the next set of conditions after the next OR true, if so, enter -1, if neither is set of conditions is true enter a 0.

This shouldn't be that hard, I don't think - I am frustrated I cannot figure this one out. Maybe too many AND's and OR's? Is there a simpler way to do this?

Thank you

[DonkeyOte]

Syntax wise this appears ok:

Please Login or Register  to view this content.

Though I confess I've not reviewed the logic in any detail.

[joeljoel]

That works, although when I put them both side by side in a Word doc, I cannot find any difference - other than the type of quotes from Word is slightly different. Could this be an issue?

Anyway, I'm not complaining - just puzzled. Hopefully I can use this for a template as I have 4 more similar columns to do, just with different date ranges.

Thanks again, DonkeyOte