Combining Nested IF functions

[Stuepef]

I have a spreadsheet that allows the user to input different employee/bonus combinations and based on the combination, I have assigned a number 1-4. For instance:
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?

=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))))))

=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)))

Combination 3 & 4 both have false statements causing the error message. Is there a way to combine these two formulas into 1? I understand this might be difficult without have the workbook to look at.</vlookup(summary!$a22,rates!$a$11:$m$60,13,false),vlookup($a22,'base></vlookup(summary!$a22,rates!$a$11:$m$60,13,false),vlookup($a22,'base>

 

[Gerald Higgins]

Hi.

The first section seems to be incomplete.

It finishes . . .
IF(VLOOKUP(Summary!$A22,'Base Plan Rates'!$A$11:$M$60,13,FALSE)

with no True or False arguments for this IF statement.

As you say, it's pretty hard to understand what is required here, without seeing the workbook.

Don't worry too much about explaining the real world application of your data, that may not be relevant, but if you can describe how the data is laid out, and what the different bits are meant to do, that might be helpful

 

[Stuepef]

This problem is too difficult without being able to upload the actual workbook.

 

[Stuepef]

I updated this question in a different post:
https://www.mrexcel.com/forum/excel...ing-too-many-arguments-error.html#post4979565