• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Using Excel's Business-Model... > Setting Up Your Worksheet for Scenar...

Setting Up Your Worksheet for Scenarios

Before creating a scenario, you need to decide which cells in your model will be the input cells. These will be the worksheet variables—the cells that, when you change them, change the results of the model. (Not surprisingly, Excel calls these the changing cells.) You can have as many as 32 changing cells in a scenario. For best results, follow these guidelines when setting up your worksheet for scenarios:

  • The changing cells should be constants. Formulas can be affected by other cells, and that can throw off the entire scenario.

  • To make it easier to set up each scenario, and to make your worksheet easier to understand, group the changing cells and label them. (See Figure 14.21.)

  • For even greater clarity, assign a range name to each changing cell.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint