+ Reply to Thread
Results 1 to 4 of 4

Multiple IF formula to input text dependent on value range

  1. #1
    Registered User
    Join Date
    05-15-2018
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    1

    Multiple IF formula to input text dependent on value range

    I've attempted to create an IF formula to input specific text dependent on the range of value.

    IF(G8<=59%,"Fail", "N/A")+IF((AND(G8=60%,G8<=79%),"Pass - Action Required", "N/A"))+IF,(((AND(G8>=80%,G8<=100%), "Pass", "N/A"))))

    I can't get this to work.

    Hope you can help!!!!!!!

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Multiple IF formula to input text dependent on value range

    Hello and welcome to the forum. Try this:

    =LOOKUP(G8,{0,0.6,0.8},{"Fail","Pass - Action Required","Pass"})

  3. #3
    Forum Contributor
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    Microsoft 365
    Posts
    154

    Re: Multiple IF formula to input text dependent on value range

    If I recall correctly you can't do a wildcard with an If Statement. That's why it's not working.

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

    Re: Multiple IF formula to input text dependent on value range

    if you want an if statement instead of what FalconDude gave you then this...
    =IF(G8<=59%,"Fail",IF(G8<=79%,"Pass - Action Required",IF(G8<=100%,"Pass","N/A")))
    Now, the problem with what you wrote is that you completed each if statement with this...
    IF(G8<=59%,"Fail", "N/A")+IF((AND(G8=60%,G8<=79%),"Pass - Action Required", "N/A"))+IF,(((AND(G8>=80%,G8<=100%), "Pass", "N/A"))))
    this... IF(G8<=59%,"Fail", "N/A") is an IF/Then statement in itself and once the criteria is/are met it stops working. The your plus signs are trying to tell it to add things together which won't work for text.
    hope that helps clarify why it wouldn't work for you.

    EDIT: by the way, you don't need the and statements for between this and that because once the IF statement becomes true it stops. So if the value in G8 is greater than 72% the part where it is equal to or below 59% is false so it goes to the next value and sees that it satisfies he part about it being less than or equal to 79% so now it stops.
    Last edited by Sam Capricci; 05-15-2018 at 11:42 AM.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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] Returning multiple values dependent on text found using IF and SEARCH Functions
    By jujub33ns in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-26-2017, 08:41 AM
  2. [SOLVED] Index/Match dependent with range dependent on another column
    By golden2282 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2016, 01:12 AM
  3. VBA for named range where the name of the range is dependent on cell input
    By pnegi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2015, 07:18 AM
  4. [SOLVED] Formula needed to auto populate in a range of cells on mult sprdsheets based on text input
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-31-2015, 06:40 PM
  5. Dependent, Dynamic Named Range with Multiple Criteria
    By JustinCredibLee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-11-2014, 12:46 PM
  6. [SOLVED] Dependent formula with value range
    By scholl43 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2014, 05:55 AM
  7. Replies: 7
    Last Post: 07-30-2012, 01:31 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