C
chrisdorn
Previously, I created several self referencing If Statements that
would return data when a toggle cell was equal to what I was looking
for and would not change if the toggle was equal to something else.
This had the effect of providing a data table without having to have
the input functions on the same tab as the table. For example, on an
excel merger model, on a cases tab I had many different "cases" (one
company acquired another at a 10% premium, 15% premium, 20%, 25%, 30%,
etc.). On another tab in cell A15, I had this if statement =if(CASES!$A
$1=A$14,RESULT,A15) then I would have this same if statement copied
and pasted throughout a range that looks like a data table. The result
being that I got a data table output without having to create a data
table since the inputs are on a different tab.
My problem is that in Excel 2003, excel seemed to run iterations until
the problem was solved, now I have to go to the cases tab to toggle
through the different options. I was wondering if there has been some
kind of functionality switch taht has caused Excel 2007 to stop doing
this. Iterations have been turned on and have ranged from 1 iteration
to 10,000. Any help would be useful.
As an aside, I cannot move the inputs to my tab or link the Cases tab
to my tab. This is not an option. Does anyone have any experience with
self referencing If statements?
would return data when a toggle cell was equal to what I was looking
for and would not change if the toggle was equal to something else.
This had the effect of providing a data table without having to have
the input functions on the same tab as the table. For example, on an
excel merger model, on a cases tab I had many different "cases" (one
company acquired another at a 10% premium, 15% premium, 20%, 25%, 30%,
etc.). On another tab in cell A15, I had this if statement =if(CASES!$A
$1=A$14,RESULT,A15) then I would have this same if statement copied
and pasted throughout a range that looks like a data table. The result
being that I got a data table output without having to create a data
table since the inputs are on a different tab.
My problem is that in Excel 2003, excel seemed to run iterations until
the problem was solved, now I have to go to the cases tab to toggle
through the different options. I was wondering if there has been some
kind of functionality switch taht has caused Excel 2007 to stop doing
this. Iterations have been turned on and have ranged from 1 iteration
to 10,000. Any help would be useful.
As an aside, I cannot move the inputs to my tab or link the Cases tab
to my tab. This is not an option. Does anyone have any experience with
self referencing If statements?