Results 1 to 8 of 8

If nested formulas, get "too many arguments" error

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    Calgary, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Exclamation If nested formulas, get "too many arguments" error

    I'm building a formula so that it will calculate royalties to be paid to an investor as follows: i) Royalties are capped at 5 million (will not pay royalties after revenue exceeds 5 million); ii) Royalty on 4th and 5th million is 2%, on 3rd Million is 4%, on 2nd million is 6%, on 1st million is 8% (i.e. on the 1st Million of Revenue). The Revenue value calculated by the spreadsheet is on cell $G$13.

    The formula that is getting me the "TOO MANY ARGUMENTS" error message is:

    =IF($G$13>5000000,((2000000*0.02)+(1000000*0.04)+(1000000*0.06)+(1000000*0.08)),IF($G$13>3000000,(($G$13-3000000)*0.02)+(1000000*0.04)+(1000000*0.06)+(1000000*0.08)),IF($G$13>2000000,(($G$13-2000000)*0.04)+(1000000*0.06)+(1000000*0.08)),IF($G$13<1000000,(($G$13-1000000)*0.06)+(1000000*0.08)))

    Please help me out! I really need a solution as soon as possible.

    Thanks!
    Last edited by jpelayo; 10-11-2013 at 02:03 AM. Reason: typo

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [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
  2. Getting "this function takes no arguments" and "#NAME?" error
    By chuckmckiel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2014, 01:58 PM
  3. Nested IFs and error message "uses more levels of nesting than allowed"
    By pannassi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-09-2012, 11:48 AM
  4. Replies: 1
    Last Post: 06-07-2012, 11:38 AM
  5. Replies: 3
    Last Post: 09-07-2009, 04:48 PM

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