Results 1 to 4 of 4

nested if formula claims there are too many arguments

Threaded View

  1. #1
    Registered User
    Join Date
    02-11-2013
    Location
    new york
    MS-Off Ver
    Excel 2013
    Posts
    3

    nested if formula claims there are too many arguments

    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!
    Last edited by asthx; 02-11-2013 at 01:30 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1