Nested IF functions not working for more than 2 nests

Hi,

I am new to the forum and have tried looking all over for a solution to my problem, but from what I can see everything in my formula should be giving me a desired result, but it is just not working. Here is the issue:

I have one sheet (Sheet A) the is for reporting purposes. It contains a column that uses a list with 4 status of the Charter listed.

Please Login or Register  to view this content.

The second sheet labelled "Data" contains dates for each status listed above, e.g. Draft = Jan. 1, 2011, Team Review= Jan. 5, 2011, PMO Review=Jan. 15, 2011 etc.

What I want to do is to check IF the cells in the Data sheet are not blank, THEN automatically enter the correct status from the Charter list. I am using nested IF functions as below:

Please Login or Register  to view this content.

The issue is that even though I have entered all dates in the Data sheet, i.e. Draft, Team Review, PMO Review, and Approved. On "Sheet 1", it only seems to be going down two levels and shows a status of "Team Review" in the cell with the formula, but it should be "Approved" since a date exists in the cell "Data!F4".

I cannot figure out what is wrong with this formula. Any help is apprecaited.

Thanks

With nested IFs, the formulas stops evaluating once it hits the first TRUE, so in your case it would never pass the first AND() set. You need to nest them in the reverse order.