Join Curt Frye for an in-depth discussion in this video Requiring integer solutions, part of Learning Excel What-If Analysis.
…In some Solver models it's okay to have decimal values in your answers.…For example, you might be looking at proportions of…products, and it's okay to go down to decimal values.…But in this case, I'm looking at a…mailing, and I can't mail 0.18 of a coupon.…So what I need to do is identify a…solution that uses only integer, or whole number values.…I will show you how to do that, using the Integer Solutions…workbook, which you can find in the…chapter two folder of your exercise files archive.…
I've already applied a Solver model to this workbook, to find…the optimum mix of coupon mailings that generate the most revenue.…The problem is that offer one and offer two both have decimal…values, and I don't know how to mail 0.18 of a coupon.…So what I want to do is require Solver to use integers only.…To do that, I'll open up the Solver dialog box by clicking the Data tab, and…then clicking Solver, there's the Solver Parameters dialog…box with the constraints that I put in.…
And now I need to add another constraint that requires cells…
- Explain how to create a scenario in Excel.
- Identify the two input values that should be used to create a two variable data table.
- Recall what the Excel feature Goal Seek is used for.
- Recognize the three things that must be separated from one another to make reading a worksheet with multiple units easier.
- Describe the tools that Excel provides to manipulate data.
- Break down the steps required to recalculate a worksheet's formulas.