# 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.  Register To Reply

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.  Register To Reply

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"))  Register To Reply

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!  Register To Reply