# If function with 3 possibilities

1. ## 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. ## 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. ## 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. ## 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!

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

#### 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