Your question isn't clear. Post the formula that is giving you problems.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"scouserabbit" wrote:

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