G
Guest
I'm getting an odd result with 2 variable data tables in a complex
spreadsheet - only the 1st (top left) cell returns the proper value, the rest
are either zero (or Div/0! errors if I try to return a percentage result).
The data table evaluates the result of a very complex formula [resulting from
offset(), vlookup() & if() statements]. However, 1 variable data tables work
correctly for each of the two variables I want in the 2 variable data table.
Can anyone shed any light on this?
spreadsheet - only the 1st (top left) cell returns the proper value, the rest
are either zero (or Div/0! errors if I try to return a percentage result).
The data table evaluates the result of a very complex formula [resulting from
offset(), vlookup() & if() statements]. However, 1 variable data tables work
correctly for each of the two variables I want in the 2 variable data table.
Can anyone shed any light on this?