I am trying to do a solver constraints in excel and having a really hard time.  The professor said to use this table, I know how to go in solver in excel but I don't know how to add the subject constraints in excel?

Constraint	Cell or Range
Each type of lesson is scheduled at least once in the morning and once in the afternoon	B5:F6
Each morning and afternoon class value is an integer	B5:F6
Each type of lesson is scheduled 3 times per week or more	B7:F7
Each type of lesson is scheduled 10 times per week or less	B7:F7
The total number of morning classes is 10 or less	Total_Morning_Classes (G5)
The total number of afternoon classes is 15 or less	Total_Afternoon_Classes (G6)
The total number of classes per week is 20	Total_Weekly_Classes (G7)
Swim team morning classes are scheduled 6 times per week or less	Team_Morning_Classes (D21)
Swim team afternoon classes are scheduled 8 times per week or less	Team_Afternoon_Classes (D22)
The total number of swim team classes scheduled per week is 12 or less	Team_Total_Classes (D23)

Answer rating: 100% (QA)

Solution EXCEL ANSWER FORMULAE FOR THE ABOVE SOLVER TAB ANSWER REPORT Result Solver found a solution ... View the full answer