Question about multiple conditionals

New Contributor

Thank you for your help in advance, I don't use excel much and I am struggling with syntax for filling in a column based on the values in the adjacent column. Mathematically it looks like this.


If 1200 < myValue < 2099 then return 3.

If 3000 < myValue < 4999 then return 4. 

If 5000 <  myValue < infinity then return 5. 


How can I encapsulate this to a single formula so I can drag it down the column to fill the entire sheet?

Thank you so much for your help again!

1 Reply


As variant

=LOOKUP( myValue,{0,3000,5000}, {3,4,5} )