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.

"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
---

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
---