nested if based on nested if in seperate sheet. how?
I have created a nested if statement that works, it brings in a certain level
based on yes or no answers. In another sheet I have used and absolute cell
reference to the first sheets cell that contains the nested if statement.
But here is where I have a problem, when I tr to create a nested if
statement on the second sheet to bring up a comment based on what the
absolute reference is currently displaying. The statement does not work.
If I take away the absolute reference and just write any number in, then the
statement works fine and the appropriate comment is displayed.
Help please
|