In this video u've formed a Table with interest rates as column headers and number of years as row headers , and then u clicked on Data Table from the tab above , but u chose interest rates as rows and number of years as columns , why that ? u should have selected the interest rates as column headers and number of years as rows as the table u've formed .

Hi, The idea is that the column in which you have interest rates will form the row inputs of the data table. And the number of years shapes the columns of the table. Please look at it like this. Best, Ned

Hi, unfortunately in notes (ppt) there is still an error which results in wrong numbers: Regards Margaret

Follow this topic

Moataz Ahmed

Last answered:

14 Mar 2023

Posted on:

03 Mar 2023

Data Table Row & Column Assigning

in Introduction to Excel / Perform Sensitivity Analysis with Excel's Data Tables Functionality

2 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

04 Mar 2023

Małgorzata Biskup

Posted on:

14 Mar 2023

Data Table Row & Column Assigning

Submit an answer

related questions