+ Reply to Thread
Results 1 to 4 of 4

If function with 3 possibilities

  1. #1
    Registered User
    Join Date
    05-30-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    21

    If function with 3 possibilities

    I am looking to display 1 of 3 possibilities based off a field's value.

    Ex:

    <100,000 then display = "small"
    100,000-1,000,000 = "Medium"
    <1,000,000 = "large"


    How do I nest these in an if statement? I can get two working, but not all three. I googled nested if statements but for some reason the third will never trigger, only small and medium seem to work.

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

    Re: If function with 3 possibilities

    Try this:

    =LOOKUP(A1,{0,100000,1000001},{"small","Medium","large"})

    Also I'm assuming that <1,000,000 should have been >1,000,000.

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

    Re: If function with 3 possibilities

    Just FYI, here is how it would look with an IF function:

    =IF(A1>1000000,"large",IF(A1>=100000,"Medium",IF(A1< 100000,"small")))

    which can be shortened to

    =IF(A1>1000000,"large",IF(A1>=100000,"Medium","small"))

  4. #4
    Registered User
    Join Date
    05-30-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    21

    Re: If function with 3 possibilities

    Just FYI, here is how it would look with an IF function:

    =IF(A1>1000000,"large",IF(A1>=100000,"Medium",IF(A1< 100000,"small")))

    which can be shortened to

    =IF(A1>1000000,"large",IF(A1>=100000,"Medium","small"))


    Thank you 63falcondude! This works great!

+ 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. IF function with multiple possibilities
    By eighcoop in forum Excel General
    Replies: 6
    Last Post: 08-15-2015, 07:44 PM
  2. IF and AND Function with 3 possibilities
    By Angelicvamp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-28-2014, 01:51 AM
  3. [SOLVED] IF function with three different possibilities
    By kbriaz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-25-2013, 08:19 PM
  4. multi-function macro possibilities?
    By andysgirl8800 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-25-2006, 10:55 PM
  5. Thousands of possibilities
    By sharkfoot in forum Excel General
    Replies: 5
    Last Post: 03-27-2006, 12:15 AM
  6. Conditional w/ three possibilities
    By MathDoctor in forum Excel General
    Replies: 4
    Last Post: 06-11-2005, 11:05 AM
  7. If Function Possibilities
    By rheller in forum Excel General
    Replies: 2
    Last Post: 06-08-2005, 11:05 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