does this execute all conditions on down the line regardless?

IIF (condition, true, false) The first one would be true for an item less than $30 and under 1 lb...so would the MAP test under the false condition even be executed?

I saw some other examples using SELECT CASE statements that look like more traditional code to me, but I am still not sure how I would incorporate this code into a query result.
...

Hello,

I am writing some pricing optimizations for an online store. What I am trying to do is adjust the sale price based upon a combination of 3 factors...cost, weight, min advertised price (MAP).

I know I could code this in VB/ASP for web...not sure how to do it in an access query. Looking around here it looks as if I might be able to do it through a complex nesting of IIF statements too, but those would look messy....