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