Query Help

Ok so want to make sure I can do this as well, And statements within either the IIF statements or the select case statement? So in excel it would look like this:

IF(AND(A2="AADIAM",B2<24001),24000,IF(AND(A2="AADIAM",B2>24000,B2<36001),36000, and so on...

Is using that and statement possible still in the IIF statements in access and or the select case statement?

Ok, so I got the Nested IIF statement to work. Found the EVAL formula.