+ Reply to Thread
Results 1 to 7 of 7

Issue with Nested Formula

  1. #1
    Registered User
    Join Date
    02-12-2019
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Issue with Nested Formula

    Hello to all.

    I am running into an issue trying to write a nested formula. The formula consists of 3 parts. I can get it to work properly with 2, but when I attempt to add the last part it fails.


    Here is what I need...

    If A1 > 100 then A1*1.15 or else A1*1.18
    If A1 < 50 then A1*1.20

    OR...

    $0-$49 Add 20%
    $50-$99 Add 18%
    $100 & Up Add 15%



    This part works... =IF(A1>100,A1*1.15,A1*1.18)


    I thought this would work, but it doesn't... =IF(A1>100,A1*1.15,A1*1.18),IF(A1<50,A1*1.2) *I get a return of #VALUE

    I then tried... =IF(A1>100,A1*1.15,A1*1.18,IF(A1<50,A1*1.2)) *I get "Too Many Arguments".


    Can anyone help?

  2. #2
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Issue with Nested Formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Issue with Nested Formula

    I thought this would work, but it doesn't... =IF(A1>100,A1*1.15,A1*1.18),IF(A1<50,A1*1.2) *I get a return of #VALUE

    I then tried... =IF(A1>100,A1*1.15,A1*1.18,IF(A1<50,A1*1.2)) *I get "Too Many Arguments
    The reasons your second and third attempts failed are that after your first argument =IF(A1>100,A1*1.15,A1*1.18),IF(
    the bold red section is the end of the statement.
    in other words, when you have a complete if then statement it goes like this, IF condition A exists, do condition B, otherwise do condition C. If you tie in another if then after the first COMPLETE one excel doesn't know what to do with that so you have too many arguments.
    That is a complete statement, if you want to nest them you would have IF condition A exists, do condition B, then next IF condition C, do condition D...
    eventually you tell the statement what to do when none of the conditions exist.
    Hope that helps when you write your next if then statement.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Registered User
    Join Date
    02-12-2019
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Re: Issue with Nested Formula

    GeoffW283, you Sir are a genius! I struggled with this for about 45 minutes. Thank you for your time.

  5. #5
    Registered User
    Join Date
    02-12-2019
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Re: Issue with Nested Formula

    Thanks Sambo Kid! I had to read your reply a few times for it to stick, but I think I got it.

  6. #6
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Issue with Nested Formula

    you're welcome, AND thank you for the rep!

  7. #7
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Issue with Nested Formula

    There are some geniuses her but I'm not one of them! Thanks anyway for the rep

+ 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] Nested if function issue
    By Vcare in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-25-2018, 05:53 AM
  2. [SOLVED] HELP! nested if formula issue
    By bigj_309 in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 04-14-2016, 08:35 AM
  3. [SOLVED] Sorting Issue Using a Nested Formula
    By avendi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-03-2015, 11:27 PM
  4. [SOLVED] Nested Formula Issue
    By Nuccio92 in forum Excel General
    Replies: 3
    Last Post: 08-26-2015, 05:42 AM
  5. I am having an issue with an IF formula that contains 4 nested arguments....
    By iamjustinpowell in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-22-2013, 04:00 PM
  6. [SOLVED] Issue with nested IF statement
    By Sc0tt1e in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-13-2013, 06:44 AM
  7. [SOLVED] Nested IF ordering issue
    By dilly in forum Excel General
    Replies: 12
    Last Post: 05-08-2012, 10:45 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