ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   data table construction (https://www.excelbanter.com/excel-discussion-misc-queries/165809-data-table-construction.html)

srkrsh

data table construction
 
i tried to understand the concept of data table by means of the example given
in the help function but i was not able to construct it . i took up the same
example of mortgage payment that is given in the help function.

i m able to calculate the pmt and i get $672.68 ,but i am not able to
construct the data table from here.

please clarify my doubt with regards to these two points:

1.Selecting the range of cells that contains formulas and values to
substitute and
2.Typing the cell reference for the input cell.


Max

data table construction
 
"srkrsh" wrote:
i tried to understand the concept of data table ..


Perhaps it might be easier to grasp the Data Table set-up principles
via these 2 illustrative samples from my archives:

http://savefile.com/files/1007074
One variable data table example.xls

http://savefile.com/files/46276
2 variable data table example.xls

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Max

data table construction
 
Think there's some problems with this link
http://savefile.com/files/46276
2 variable data table example.xls


Here's an alternative link:
http://www.savefile.com/files/1192572
Two_variable_data_table_example.xls

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com