A = 1

A+B = 2

A+C = 3

A*B = 4

I created a large nested IF statement to account for every combination, but I have two combinations that utilize the false argument with two separate IF statements causing the "Too many arguments" error message when I try to combine them. Is there a way to combine these two IF statements into one formula?

Code:

`=IF('Input Data'!$E$10=2,IF(SUM(Rates!$E11:$F11)<1,0,1)*'Input Data'!$F$23+'Input Data'!$F$21,IF('Input Data'!$E$10=6,VLOOKUP(VLOOKUP(Summary!$A22,'Input Data'!$L$35:$M$84,2,FALSE),'Input Data'!$E$26:$G$30,2,FALSE)*Rates!M11+VLOOKUP(VLOOKUP($A22,'Input Data'!$L$35:$M$84,2,FALSE),'Input Data'!$E$26:$G$30,3,FALSE)*(Rates!N11+Rates!O11),IF('Input Data'!$E$10=1,'Input Data'!$F$17*Rates!M11+'Input Data'!$F$19*(Rates!N11+Rates!O11),IF('Input Data'!$E$10=3,IF(VLOOKUP(Summary!$A22,'Base Plan Rates'!$A$11:$M$60,13,FALSE)<vlookup(summary!$a22,rates!$a$11:$m$60,13,false),vlookup($a22,'base plan="" rates'!$a$11:$m$60,13,false)*'input="" data'!$f$17+'input="" data'!$f$19*(rates!n11+rates!o11),vlookup(summary!$a22,rates!$a$11:$m$60,13,false)*'input="" data'!$f$19*(rates!n11+rates!o11))))))`

Code:

`=IF('Input Data'!$E$10=4,IF(VLOOKUP(Summary!$A22,'Base Plan Rates'!$A$11:$M$60,13,FALSE)<vlookup(summary!$a22,rates!$a$11:$m$60,13,false),vlookup($a22,'base plan="" rates'!$a$11:$m$60,13,false)*vlookup(vlookup(summary!$a22,'input="" data'!$l$35:$m$84,2,false),'input="" data'!$e$26:$g$30,2,false)+(rates!n11+rates!o11)*vlookup(vlookup(summary!$a22,'input="" data'!$e$26:$g$30,3,false),vlookup(summary!$a22,rates!$a$11:$m$60,13,false)*vlookup(vlookup(summary!$a22,'input="" data'!$e$26:$g$30,3,false)))`