nested if formula claims there are too many arguments

**asthx** · 02-11-2013, 01:21 AM

But I've read that the new versions of excel allow for up to 64 nested if functions.
I need to nest about 5 if functions, but after I write out the 3rd excel says there are too many arguments.

=IF(INDEX(vlookup!$D$2:$D$157,MATCH($F16,vlookup!$B$2:$B$157,0))="CPM", INDEX(vlookup!$E$2:$E$157,MATCH($F16,vlookup!$B$2:$B$157,0))*(J16/1000), IF(INDEX(vlookup!$D$2:$D$157,MATCH($F16,vlookup!$B$2:$B$157,0))="CPA", INDEX(vlookup!$E$2:$E$157,MATCH($F16,vlookup!$B$2:$B$157,0))*(L16), IF(INDEX(vlookup!$D$2:$D$157,MATCH($F16,vlookup!$B$2:$B$157,0))="dCPM", 0.04*(j3/1000))), IF(INDEX(vlookup!$D$2:$D$157,MATCH($F16,vlookup!$B$2:$B$157,0))="dCPC", 0.008*k3, "calc"))

ANy help would be greatly appreciated.

Thanks!

**vlady** · 02-11-2013, 01:38 AM

since i can't test just try this. if doesn't work can you post a sample workbook with sample data.

Formula:

=IFERROR(IF(INDEX(vlookup!$D$2:$D$157,MATCH($F16,vlookup!$B$2:$B$157,0))="CPM", INDEX(vlookup!$E$2:$E$157,(MATCH($F16,vlookup!$B$2:$B$157,0)))*(J16/1000),IF(INDEX(vlookup!$D$2:$D$157,MATCH($F16,vlookup!$B$2:$B$157,0))="CPA",INDEX(vlookup!$E$2:$E$157,MATCH($F16,vlookup!$B$2:$B$157,0))*(L16),IF(INDEX(vlookup!$D$2:$D$157,MATCH($F16,vlookup!$B$2:$B$157,0))="dCPM", 0.04*(je/1000),IF(INDEX(vlookup!$D$2:$D$157,MATCH($F16,vlookup!$B$2:$B$157,0))="dCPC", 0.008*K3,"calc")))),"")

**asthx** · 02-11-2013, 01:46 AM

Actually, that seemed to do the trick. Thank you so much!
Would you mind explaining what was wrong about the way I wrote it, and why you did what you did?

**vlady** · 02-11-2013, 01:49 AM

hard to find the error but its the open close parenthesis just to find the right spot to close. some has missing close and some have extra close.

i issued also the iferror in case there are no matches found to return null.
let's put it this way,, two eyes are better than one.

cheers,
Regards,
Vladimir