I am buying 50 pounds of candy. Some of the candy sells for $10 per pound, the other for $6 per pound.
How much candy at each price should I buy to arrive at an average cost of $7 per pound.
Use Goal Seek to solve.
Total pounds	50
Candy 1 per pound	$10.00
Candy 1 ordered	0	*this will be the cell you want changed
Candy 2 per pound	$6.00
Candy 2 ordered	50
Goal per pound	$7.00
Total $ amount	$300.00
*Hint, what Total $ amount will be needed for it to equal $7/pound