=E1*(CHOOSE(CODE(A1)-96,4,4.25,4.5,5)*B1+C1+D1)

Where A1 contains the code for price by yard either a or b or c or d
Where B1 contains the number of yards
Where C1conains the shipping charge
Where D1 contains the paddding charge
--
Gary''s Student - gsnu200737