If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Limitations to 2 variable data tables?
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? |
#2
|
|||
|
|||
Limitations to 2 variable data tables?
You would really need to post your formula - but it is likely that you need to change some cell
addresses to absolute column, and others to absolute rows. For example, to create a table from variables in row 1 and column A, you would change this formula in cell B2 =B1*A2 to this =B$1 * $A2 to copy to, say, B2:G10 HTH, Bernie MS Excel MVP "DInwood" wrote in message ... 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? |
#3
|
|||
|
|||
Limitations to 2 variable data tables?
Just some guesses ..
Maybe try re-doing the Data Table set-up, swap the row & col input cells around (you might have done it the wrong way around earlier?). If the results are still out, check whether there could be combinations of "row-input" values entered to the right of the top left cell & "col-input" values entered below the top left cell which would lead to output zeros/errors by plugging some sample combinations of these directly into the base formula itself. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "DInwood" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|