+ Reply to Thread
Results 1 to 6 of 6

IF formula with multiple characteristics

  1. #1
    Registered User
    Join Date
    10-11-2023
    Location
    Iowa
    MS-Off Ver
    365
    Posts
    2

    IF formula with multiple characteristics

    Hello

    I am attempting to create a formula where there are three options for results based on a range of numbers. My results need to be either the words Partner, Premier or a blank cell.

    My struggle is the values of which each must be. If the number in a column is less than 6, it needs to be blank. If the number is 6 to 11, it needs to be Partner. If the number is 12 or more, it needs to be Premier.

    I can get the IF function to work for the less than 6 or greater than 11. But the mid range is throwing me off. Any help would be greatly appreciated.

    =IF(AND(C3>5,C3<12),"Partner","") is the formula I have. Blank and Partner are showing up, but not Premier.

    I'm driving myself nuts here. lol

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,832

    Re: IF formula with multiple characteristics

    I don't see how your formula matches up to what you are asking, so ignoring your formula, I would suggest this:
    (assumes the cell where the value is is A1)

    =IF(A1<6,"",IF(A1<=11,"Partner","Premier"))

    Edited: Oops, sorry, I do see now how your formula matches. Of course you'd replace my A1 with C3

  3. #3
    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: IF formula with multiple characteristics

    is this what you want... =IF(C3<6,"",IF(C3<12,"Partner","Premier"))

    EDIT: and it assumes that the numbers are whole numbers - no decimals.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Registered User
    Join Date
    10-11-2023
    Location
    Iowa
    MS-Off Ver
    365
    Posts
    2

    Re: IF formula with multiple characteristics

    OMG you guys are amazing
    Thank you! I was overthinking it!

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: IF formula with multiple characteristics

    Welcome to the forum, angelm77.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

    Thanks
    Dave

  6. #6
    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: IF formula with multiple characteristics

    Glad if I was able to help. Since you are new to this forum a way to say thanks to ANY and ALL that stoped by to assist is to click the * Add Reputation under their post, that is the only way we advance on this forum.

+ 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: 6
    Last Post: 06-13-2021, 05:28 AM
  2. Replies: 9
    Last Post: 02-28-2019, 05:52 PM
  3. Replies: 5
    Last Post: 09-26-2015, 12:02 AM
  4. [SOLVED] Seach value in matrix with multiple characteristics
    By keis386 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-25-2015, 06:17 AM
  5. Replies: 1
    Last Post: 10-29-2012, 10:17 PM
  6. Sum formula with multiple characteristics
    By rhudgins in forum Excel General
    Replies: 3
    Last Post: 12-20-2010, 05:01 PM
  7. Changing Font Characteristics Within a Formula
    By jdurrmsu in forum Excel General
    Replies: 3
    Last Post: 09-14-2005, 05:05 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