Multiple If Statement with a Greater or Less than Function

[HRBonne]

I am trying to write a Multiple IF Statement and incorporate a greater or less than fuction....

If A1 > 500 = L
If A1< 150 = B
If A1 <500 or >150 = A

Below is my formula....any help would be greatly appreciated

=if(A1>500,"L",if(A1<150,"B",if(A1>150and<500,"A",0)))

Thanks!

[JBeaucaire]

How about this:

=LOOKUP(A1, {0,150,500}. {"B","A","L"})

The "A" value will start at the value 150 exactly, "L" will start at 500 exactly.

[HRBonne]

I just figured it out.....

=IF(A1>500,"L",IF(A1<150,"A",IF(AND(A1>150=TRUE,A1<500=TRUE),"B","False")))

Thank you for your suggestion though.

HRBonne