+ Reply to Thread
Results 1 to 3 of 3

Nested IF Function and the Too Many Arguments Error

  1. #1
    Registered User
    Join Date
    04-25-2021
    Location
    Melbourne, Australia
    MS-Off Ver
    Windows 10 Enterprise
    Posts
    2

    Nested IF Function and the Too Many Arguments Error

    Hello

    I'm trying to make a budget planner that converts each expense into the cost per fortnight (two weeks).

    The cells are as follows:
    C3 - Expense
    D3 - Expense amount
    E3 - Expense frequency (dropdown list)
    F3 - Formula cell (conversion to fortnightly cost)

    I want the user to input the amount in D3 and select the frequency from the dropdown list in E3.
    I want F3 to read the value in E3 and then display the converted amount based on the two inputs.

    Example:
    ------- C3 -----------D3-------E3--------F3----
    Phone & Internet | $100 | Monthly | $46.15


    OK, so the formula I'm using works when there are 3 or less IF arguments, however doesn't work for 4+ IF arguments because Excel reads the 4th/5th/6th argument as part of the first IF argument and returns the 'too many arguments' error.
    How do I set out the formula so that it reads only what it needs to for each IF function?

    This is my formula:
    IF(E3="Weekly",D3*2, IF(E3="Fortnightly",D3, IF(E3="Monthly",(D3*12)/26, IF(E3="Quarterly",(D3*4)/26), IF(E3="6 Months",(D3*2)/26, IF(E3="Yearly",D3/26))))))

    This formula works perfectly:
    IF(E3="Weekly",D3*2, IF(E3="Fortnightly",D3, IF(E3="Monthly",(D3*12)/26)))
    Last edited by sainters; 04-25-2021 at 11:15 PM.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Nested IF Function and the Too Many Arguments Error

    =IF(E3="Weekly",D3*2, IF(E3="Fortnightly",D3, IF(E3="Monthly",(D3*12)/26, IF(E3="Quarterly",(D3*4)/26), IF(E3="6 Months",
    (D3*2)/26, IF(E3="Yearly",D3/26))))))

    Remove the extra ) then it sholud works.

    BTW, D3 could be moved out to be shorten:

    Please Login or Register  to view this content.
    Quang PT

  3. #3
    Registered User
    Join Date
    04-25-2021
    Location
    Melbourne, Australia
    MS-Off Ver
    Windows 10 Enterprise
    Posts
    2

    Re: Nested IF Function and the Too Many Arguments Error

    Thank you!! It may not seem like it but I did look over the formula checking the parenthesis were correct. Obviously missed that one!
    It's working perfectly now

+ 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. Replies: 4
    Last Post: 01-06-2021, 03:25 PM
  2. [SOLVED] Nested IF function error "You've entered too many arguments..."
    By lhendrickson in forum Excel General
    Replies: 15
    Last Post: 11-19-2018, 09:53 AM
  3. Replies: 4
    Last Post: 08-31-2017, 02:52 PM
  4. [SOLVED] Nested IF AND giving a too many arguments error
    By rlh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-25-2017, 07:59 PM
  5. Nested IF function error "You've entered too many arguments..."
    By lovetofly32 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-14-2014, 08:33 PM
  6. Too many arguments in nested if function
    By floridashaughn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2014, 02:23 PM
  7. [SOLVED] Too many arguments for this function error
    By cyberjoe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-03-2012, 03:25 PM

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