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

Creating Scenarios

A model with named scenarios should have a clear set of one or more key input values and a clear set of one or more result values that will change based on the inputs. Figure 32.1 shows a Five Year Forecast worksheet. The results in rows 5 through 13 are from formulas that use the input values in the range D16:D19.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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