More Data Table Problems
 

Some of my 2-dimensional data tables stopped working when I made some
changes to a file. Am I right that the column and row input row variables
CAN be used in the row across the top and column down the side? That is,
none of these needs to be a number?

For example, I have a 5X5 data table with the row variable being cell D4,
and the entries across the top are d4-100,000, d4 - 50,000, d4, d4+50,000,
d4 +100,000. Is this legal? Strangely, a value does appear beneath the 4th
entry (d4+50,000), but not below any of the others - they all show "#Value".
I'm talking about the first row here and coincidentally, the column entry is
a number there, whereas for the other rows, they are equations.

In the 2nd row, they all show #value. If I change one of the column
scenarios to be tied directly to the column input variable, it does not help
and, from the answer showing in the top left corner of the data table, I
know this does have a real answer.

Do data tables have known problems? It seems like they are finicky?

I tried erasing it and copying it in from the older file that did work, but
it did not copy the data table matrix formulas. Then I just tired redoing
the data table, but that did not help either.

Thanks!
Dean

More Data Table Problems
 

Please ignore this last post - I have traced the problem to a cell that I
changed to have an IF statement, though it makes no sense, why only the one
value is computing, I think it's not worth the hunt. I don't have to have
the IF statement.

Comments on finicky data tables are still appreciated, though.

Thanks!
Dean

"Dean" wrote in message
...
Some of my 2-dimensional data tables stopped working when I made some
changes to a file. Am I right that the column and row input row variables
CAN be used in the row across the top and column down the side? That is,
none of these needs to be a number?

For example, I have a 5X5 data table with the row variable being cell D4,
and the entries across the top are d4-100,000, d4 - 50,000, d4, d4+50,000,
d4 +100,000. Is this legal? Strangely, a value does appear beneath the
4th entry (d4+50,000), but not below any of the others - they all show
"#Value". I'm talking about the first row here and coincidentally, the
column entry is a number there, whereas for the other rows, they are
equations.

In the 2nd row, they all show #value. If I change one of the column
scenarios to be tied directly to the column input variable, it does not
help and, from the answer showing in the top left corner of the data
table, I know this does have a real answer.

Do data tables have known problems? It seems like they are finicky?

I tried erasing it and copying it in from the older file that did work,
but it did not copy the data table matrix formulas. Then I just tired
redoing the data table, but that did not help either.

Thanks!
Dean