In I14 we need to calculate the total cost for the quantity shown in column G, but we also need to include a check that the item is actually in stock, if it isn't the formula should return 0. After you have copied down you will observe that there is one 0 value item and it has highlighted in red to warn us. Change the item code from S1009 to S1008 to correct the problem.and I have over stocked information. Just wanna know the formula for this part.

DIRECT MATERIALS Req.No. Item Code Details/Description Quantity Cost/Unit Amount 223 M1021 MGX 8025 Chip Set 108.40 224 R1004 Robot Kit 38G 3,288.90 228 R1024 Relays - Medium Pack 271.90 225 S1009 Servo Motors B21 (4 pack) 1,204.30 225 $1010 Servo Motors A21 (8 pack) 1,942.50 225 $1014 SMC Pneumatic Part X-33 709.20