# IF Statement based on number meeting certain criteria

1. ## IF Statement based on number meeting certain criteria

Hello,

Been trying to figure out how to write an if statement that will output a string based on if a number falls within a certain range.

My criteria is below:

Category 1 <10,000
Category 2 10,000 - 15,000
Category 3 15,000 - 20,000
Category 4 >20,000

So if I input 8,00 in cell B3, then it should output "Category 1", and so on, based on the above criteria. Thanks!

2. ## Re: IF Statement based on number meeting certain criteria

=LOOKUP(B3,{0;10000;15000;20000},{"Category 1";"Category 2";"Category 3";"Category 4"})

depends where your boundaries truly fall eg which group 15000 is in

3. ## Re: IF Statement based on number meeting certain criteria

Or
Formula:
`Please Login or Register  to view this content.`

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