1, the computer opens the Excel table and lists the cost price, selling price, sales volume and profit.

2. After listing the cost price, selling price, sold quantity and profit, enter the formula =(F2-E2)*G2, (selling price-cost price) * profit in the profit.

3. After entering the formula, press Enter to get the profit.