From the course: Learning Excel What-If Analysis
Join today to access over 25,500 courses taught by industry experts.
Define constraints - Microsoft Excel Tutorial
From the course: Learning Excel What-If Analysis
Define constraints
- [Instructor] Solver is designed to find the best solution for a problem given a series of constraints. For example, you might have a limited total budget, limited supply of a product, or a contractual requirement to keep product stock above a minimum level. In this movie, I will show you how to add constraints to a Solver model for an investment portfolio. My sample file is "02_05_Constraints," And you can find that in the chapter two folder of the exercise files collection. I have described this model elsewhere in the course, so I won't go into it in detail here. But what I want to do is to start defining my Solver model given the inputs that I have, such as total cash on hand and my target risk level, and also the constraints for minimum and maximum investments in each of the six funds that I have available. To do that, I need to define my Solver model. So I will go to the Data tab of the ribbon. And then in the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.