# I am trying to do a solver constraints in excel and having a really hard time. The professor said to

This problem has been solved!

Do you need an answer to a question different from the above? Ask your question!

## Question:

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) |

**View Solution**

Create a free account to access the answer

**Cannot find your solution?**

Post a FREE question now and get an answer within minutes.
* Average response time.