If this AND this, OR that AND that from lists

[COMMERCIALCHRIS]

I am creating a bid estimating sheet. It is derived from a pricing sheet from a supplier. The estimater, will pick the materials (B1,B9,B13,B), " SS304X4, Galv, Cold Rolled, Tube" from a list. The selection will generate another list from gauges or diameter available per product. For each material/gauge,diameter selected a price needs to be derived from ((estimated weight*price per pound)/(width*length)=(E4*F4)/(C4*D4) on sheet 2, giving a cost per sq inch.
On Sheet 1 A1 is the quantity of items, B1 is Material, C1 is gauge of material, D1 is width ordered, E1 is length ordered, and F1 is the sum/product, =IF((AND(B2="SS304X4",C2=24)),(Sheet2!K4*E2*D2*A2),). This function only gives me "SS304X4 and 24" . I need to have an array or nested IFs, ANDs, AND/ORs, I believe.