You can also define the constraint that one or more variables must be integers (values without decimals), or binary values (where only 0 and 1 are allowed). For example, you can set the constraint that one of the variables or cells must not be bigger than another variable, or not bigger than a given value. For arguments that you would like to change, you need to add two rules to define a range of possible values: the limiting conditions. ![]() If you want the argument to remain unchanged, you enter a rule that the cell that contains it should be equal to its current entry. It is specifically designed to minimize or maximize the result according to a set of rules that you define.Įach of these rules defines whether an argument in the formula should be greater than, lesser than, or equal to the figure you enter. The difference is that the Solver deals with equations with multiple unknown variables. ![]() Tools > Solver amounts to a more elaborate form of Goal Seek.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |