IF - returning a value between a range of numbers

Hi,
Its probably already been answered here, but I need to return a value if a figure in L5 is between multiple ranges, ie if L5 is less or equal to 400, return a value, if L5 is equal or greater than 401, but less or equal to 1100, return a different value, and if L5 is greater or equal to 1101, but less or equal to 2300, return a separate value.

What I have is:

=if(L5<=400,4,if(AND(L5>=401,L5<=1100),5,if(AND(L5>=1101,L5<=2300),6)))

Is this a valid function - can you nest AND statements within IF statements?

Any help would be much appreciated!

Thanks

Originally Posted by NBVC

Something like:

=Lookup(L5,{0,401,1101,2301},{4,5,6,"out of range"})

Thanks - i've tried this, but returns the value "4" no matter the value of L5.
I'll keep trying!


Thanks

Also pay attention to the fact that the two arrays are between curly brackets {}