![]() ![]() This would create a scenario table instantly. Therefore, for row input cell give a link to B2 (that contains years and in our table years are there horizontally) and for column input cell give a link to B4 (that contains interest rate and in our table interest rate is there vertically) In our original calculation, the interest rate is in the cell B4, and the number of years cell is in the cell B2. We have arranged our new tables like different interest rates vertically and different years horizontally. Go to Data, then select What if Analysis and Data Table. ![]() Select the data table that we have created for creating scenarios.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |