revolutionjae.blogg.se

The name of the new scenario is displayed in the scenarios list title bar. To add another scenario to the drop-down list, select all the cells in the scenarios area, choose Tools > Scenarios, create the new scenario, and click OK. In the Create Scenarios window, type a name for the scenario, add comments about the scenario, and mark the settings you want. Each non-adjacent cell will have its own drop-down list, but you can switch among scenarios from any of the non-adjacent drop-down lists to change all non-adjacent cell values. All selected cells will be included in your scenarios. You can select cells vertically and horizontally. If you only have one cell you want to create a drop-down list for, just leave the second cell blank. You must select at least two cells to create a scenario. Select the cells you want to include in your scenarios. In particular, set up row or column labels next to the values that will be used in the scenarios. Examples of scenariosīefore you jump in and start creating scenarios, set up your spreadsheet, and try to group your scenario variables in a single area of the spreadsheet.

A single drop-down list contains multiple scenarios.įigure 22-6 shows three examples of scenarios. In the latter example, each home equity lender you set up would be a single scenario. The cells containing these values, in turn, can be referenced in formulas elsewhere in your spreadsheet to calculate things like the total amount of money you can borrow from that lender, the total amount of interest you'll end up paying, and how much of your credit card debt you'll be able to pay off with the loan amount. As you select a different lender, you get different values for things like annual percentage rate, the percentage of equity you can borrow against, and the number of loan years. In a more involved example, you could set up a scenarios list that lets you choose among names of different home equity lenders.

That cell, in turn, is used in formulas elsewhere in the spreadsheet so when you select a different percentage rate from the drop-down list, the values in the spreadsheet adjust automatically. In its fullest form, it lets you enclose a set group of cells whose contents change when you select a different item from the drop-down list.įor example, you could set up a scenarios list that lets you choose among different percentage rates for a cell. In its simplest form, it lets you create a drop-down list of values to select from for a given cell. Calc's scenarios tool is one of the coolest features any spreadsheet application could provide.