The invention provides a method for designing a formula of compound feed for growing-finishing pigs. The method for designing the formula of the compound feed for the growing-finishing pigs is convenient to operate and flexible in adjustment. According to the method for designing the formula of the compound feed for the growing-finishing pigs, the programming solver in the add-ins provided by the Microsoft Office Excel is used for calculating the formula of the compound feed with the lowest cost. The method for designing the formula of the compound feed for the growing-finishing pigs has the advantages that data representation is visual, calculation is convenient, data can be easily modified, software special for feed formulas does not need to be used, and on an Excel interface, the formula of the compound feed with the lowest cost can be calculated through operations of a mouse or a keyboard; nutritive ingredients of raw materials of the feed can be determined according to numerical values published in latest Tables of Feed Composition and Nutritive Values in China, relative raw material standards and products, and can also be obtained according to actually-measured values of the nutritive ingredients of the raw materials of the feed, and practicability is good. The method for designing the formula of the compound feed for the growing-finishing pigs further has the advantages that easiness, rapidness, accuracy, convenience and the like are achieved, and the method for designing the formula of the compound feed for the growing-finishing pigs is quite applicable to feed formula optimal design of various small and medium-sized feed plants and small and medium-sized farms.