Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Data Table Alternative

Hi,

I'm finding an alternative to Excel Data Table, in Excel it appears in Data -> What-if Analysis -> Data Table. This helps me to calculate the results of 1 cell with different values of 1 or 2 variables. I post here a photo to understand it better:

DataTable

On the top-left (A1) I write the cell that I want the results, and the row at the right (B1:V1) these are constants that uses the variable_A, below A1, the column from (A2:A22) these are constants that uses variable_B. And the body of the table are the combinations from variable_A and variable_B that gives A1.

Thanks

Data Table Alternative

Hi,

I'm finding an alternative to Excel Data Table, in Excel it appears in Data -> What-if Analysis -> Data Table. This helps me to calculate the results of 1 cell with different values of 1 or 2 variables. I post here a photo to understand it better:

DataTable http://imgur.com/a/FxmsK

On the top-left (A1) I write the cell that I want the results, and the row at the right (B1:V1) these are constants that uses the variable_A, below A1, the column from (A2:A22) these are constants that uses variable_B. And the body of the table are the combinations from variable_A and variable_B that gives A1.

Thanks