Why Am I getting too many arguments for function

[nirvehex]

Hi,

I feel like I've rewritten and modified this formula over and over again, but can't figure out where I'm missing something. I'm getting a "too many arguments for this function" error for the following nested if:

=IF(OR(F7="Y",AN7<=6),AQ7,IF(AND(O7="N",SEARCH("Open",D7),AQ7>=3),AQ7,IF(AND(O7="Y",SEARCH("Open",D7),AQ7>=2),AQ7,IF(AND(SEARCH("Open",D7),O7="N"),IF(OR(AND(VLOOKUP(A7,'WOs (DSP Only)'!A:B,2,FALSE)>=3,(365/((AN7*AQ7)/VLOOKUP(A7,'WOs (DSP Only)'!A:B,2,FALSE)))>Details!AR7),AND(VLOOKUP(A7,'WOs (DSP Only)'!A:C,3,FALSE)>=3,(365/((AN7*AQ7)/VLOOKUP(A7,'WOs (DSP Only)'!A:C,3,FALSE)))>Details!AR7),AND(VLOOKUP(A7,'WOs (DSP Only)'!A:D,4,FALSE)>=3,(365/((AN7*AQ7)/VLOOKUP(A7,'WOs (DSP Only)'!A:D,4,FALSE)))>Details!AR7),AND(VLOOKUP(A7,'WOs (DSP Only)'!A:E,5,FALSE)>=3,(365/((AN7*AQ7)/VLOOKUP(A7,'WOs (DSP Only)'!A:E,5,FALSE)))>Details!AR7),AND(VLOOKUP(A7,'WOs (DSP Only)'!A:F,6,FALSE)>=3,(365/((AN7*AQ7)/VLOOKUP(A7,'WOs (DSP Only)'!A:F,6,FALSE)))>Details!AR7)),3,if(and(O7="N",SEARCH("Open",D7),VLOOKUP(A7,'WOs (DSP Only)'!A:B,2,FALSE)<2,VLOOKUP(A7,'WOs (DSP Only)'!A:c,3,FALSE)<2,VLOOKUP(A7,'WOs (DSP Only)'!A:d,4,FALSE)<2,VLOOKUP(A7,'WOs (DSP Only)'!A:e,5,FALSE)<2,VLOOKUP(A7,'WOs (DSP Only)'!A:f,6,FALSE)<2,(365/((AN7*AQ7)/VLOOKUP(CONCAT(D7,"-",O7),Calibration!P:S,4,FALSE)))>AR7),2,AQ7,IF(AND(VLOOKUP(A7,'WOs (DSP Only)'!A:B,2,FALSE)>=2,VLOOKUP(A7,'WOs (DSP Only)'!A:B,2,FALSE)<3,ROUNDDOWN(365/((AN7*AQ7)/VLOOKUP(A7,'WOs (DSP Only)'!A:B,2,FALSE)),0)>ROUNDDOWN(AR7,0)),VLOOKUP(A7,'WOs (DSP Only)'!A:B,2,FALSE),IF(AND(VLOOKUP(A7,'WOs (DSP Only)'!A:C,3,FALSE)>=2,VLOOKUP(A7,'WOs (DSP Only)'!A:C,3,FALSE)<3,ROUNDDOWN(365/((AN7*AQ7)/VLOOKUP(A7,'WOs (DSP Only)'!A:C,3,FALSE)),0)>ROUNDDOWN(AR7,0)),VLOOKUP(A7,'WOs (DSP Only)'!A:C,3,FALSE),IF(AND(VLOOKUP(A7,'WOs (DSP Only)'!A:D,4,FALSE)>=2,VLOOKUP(A7,'WOs (DSP Only)'!A:D,4,FALSE)<3,ROUNDDOWN(365/((AN7*AQ7)/VLOOKUP(A7,'WOs (DSP Only)'!A:D,4,FALSE)),0)>ROUNDDOWN(AR7,0)),VLOOKUP(A7,'WOs (DSP Only)'!A:D,4,FALSE),IF(AND(VLOOKUP(A7,'WOs (DSP Only)'!A:E,5,FALSE)>=2,VLOOKUP(A7,'WOs (DSP Only)'!A:E,5,FALSE)<3,ROUNDDOWN(365/((AN7*AQ7)/VLOOKUP(A7,'WOs (DSP Only)'!A:E,5,FALSE)),0)>ROUNDDOWN(AR7,0)),VLOOKUP(A7,'WOs (DSP Only)'!A:E,5,FALSE),IF(AND(VLOOKUP(A7,'WOs (DSP Only)'!A:F,6,FALSE)>=2,VLOOKUP(A7,'WOs (DSP Only)'!A:F,6,FALSE)<3,ROUNDDOWN(365/((AN7*AQ7)/VLOOKUP(A7,'WOs (DSP Only)'!A:F,6,FALSE)),0)>ROUNDDOWN(AR7,0)),VLOOKUP(A7,'WOs (DSP Only)'!A:F,6,FALSE)))))))))))

Thought a second set of eyes might help. Anyone have any ideas where the error is?

Thanks!

 

[nirvehex]

Nevermind, I figured it out.