G
Guest
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
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