+ Reply to Thread
Results 1 to 5 of 5

Too many arguments?

  1. #1
    Registered User
    Join Date
    08-25-2015
    Location
    Brisbane, Australia
    MS-Off Ver
    Office 2013
    Posts
    3

    Too many arguments?

    Hey All!

    I am trying to input the below formula and it worked fine until I added in the bolded section which now brings up the error "You've entered too many arguments for this function."

    This is the formula...

    =+IF(A2="NSW",K2&".20",IF(A2="QLD",K2&".40",IF(A2="VIC",K2&".30",IF(A2="WA",K2&".50",K2&".00",IF(A2="ACT",K2&".21")))))

    Can anyone help with this and why its no longer working? How can I possibly shorten it?

    Thanks
    Jamie

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Too many arguments?

    IF has three arguments: A test, output when true, output when false.

    Your 4th IF contains a test, true statement, a false statement, and a 4th argument ",IF(A2="ACT",K2&".21")".

    You will need to reconcile the False statement with how you wish to incorporate your final IF function.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    08-25-2015
    Location
    Brisbane, Australia
    MS-Off Ver
    Office 2013
    Posts
    3

    Re: Too many arguments?

    Thanks heaps!

  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Too many arguments?

    This would work:

    =K2&IFERROR(VLOOKUP(A2,{"NSW",".20";"QLD",".40";"VIC",".30";"WA",".50";"ACT",".21"},2,0),".00")

  5. #5
    Registered User
    Join Date
    08-25-2015
    Location
    Brisbane, Australia
    MS-Off Ver
    Office 2013
    Posts
    3

    Re: Too many arguments?

    Awesome - that's a much clearer formula!

    Thanks again! That has worked perfectly!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Too Many Arguments
    By Allisongw in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-19-2015, 10:59 PM
  2. To Many Arguments
    By xx8josh9xx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2014, 04:21 PM
  3. [SOLVED] Too Many Arguments
    By RicktheBlade in forum Excel General
    Replies: 3
    Last Post: 09-04-2012, 09:07 PM
  4. Too Many Arguments
    By martinpe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2008, 02:07 AM
  5. Too many arguments
    By spoko in forum Excel General
    Replies: 5
    Last Post: 05-24-2007, 10:51 PM
  6. > < = arguments
    By Papirossa in forum Excel General
    Replies: 4
    Last Post: 10-24-2006, 06:46 AM
  7. Too few arguments
    By plore in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2005, 08:50 AM

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