View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

.. 'In the column input cell box, enter reference to the
input cell for the varying values listed in the column.'
Also asks me the same for the rows as well...


Sounds like what you're looking for is pertaining to a 2 variable data
table. The "Column input cell" & "Row input cell" boxes are required inputs
which appear in the "Table" dialog when you select a range and then click
Data Table. The 2 inputs to be entered in the boxes are the actual
precedent cell references, for e.g. A2, B2, assuming A2 and B2 are the 2
precedent cells (i.e. the 2 variables of interest) used to compute the final
what-if results.

For an example set-up of a 2 variable data table which reads both row and
column inputs to output what-if results,
try: http://tinyurl.com/d9gfv

For an example set-up of a one variable data table,
try: http://tinyurl.com/562dj

And you could also type: data tables
in Excel's help for more info
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----