Data Table (list of values)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Do the list of values in the data table tool have to be values? Can they be
formulas? Appears that formulas don't work. Is there a way to work around
this problem if it is in fact the case?
 
ExcelGolfer: Data tables don't have to be values only they can certainly be
formulas. Send the exact formulas and I'll see if I can assist.
 
Thanks Mathew for help. Appears that I found the problem: as part of the list
of values, I had a link to the input cell (I was trying to get data that
surrounded (+/-)the input cell: b5=b6-1000, b6=input cell, b7=b6+1000). So at
first I thought it was the formulas. Instead, it's the link to the input
cell. Looks like this confuses excel as it generated incorrect results in the
data table. Once I eliminated the link, the calculations worked.

However, this leads to the question of whether you can include a link to the
input cell in the list of values? In my case, it would be useful in
immediately seeing some sensitivty charts (based on the data table) without
having to manipulate the list of values to "surround" the input cell.
 
Back
Top