IF Statement based on number meeting certain criteria

[jk2391]

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!

[davsth]

=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

[arthurbr]

Or

Please Login or Register  to view this content.