| | | Guest |  |
|  Posted: Mon Aug 25, 2008 4:16 pm Post subject: Self Referencing If Statements, Iterations |  |
| |  | |
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? |
|
