Help with "IF" Formula with conditions--

[Rhettvb]

Hello Users,

I could sure use some help with a formula. Since I am not an Excel Ninja by any stretch of the imagination, I can't seem to get this formula right.

I am comparing a new tab called "Analyst 1" to an original tab called "Master". The analyst is to select from a massive list of different options, each option having a drop-down box with at least two possible selections. I am trying to generating the results on a different tab called "Results". I want to create an outcome where, depending on the Analyst's answers compared to the Master, 1 of the 5 options below appears in the cell (blank, "Missing PoL"/"Extra PoL", or Correct/Incorrect).

If Analyst 1 B3=0 & If Master B3=0 then “”

If Analyst 1 B3=0 & If Master B3≠0 then “Missed PoL”

If Analyst 1 B3≠0 & If Master B3 =0 then “Extra PoL”

If Analyst 1 B3=Master then “Correct”, “Incorrect”

The formula that I have come up with follows, but it never seems to work right. Either there is an error of some kind, or the word 'FALSE' makes its way into the box. Here is one of the many variations of the formula that I am working on:

=IF('Analyst 1'!B3=0,"",IF(Master!B3=0,"Correct No PoL","Extra PoL"),IF('Analyst 1'!B3=Master!B3,"Correct","Incorrect"))

Any help would be greatly appreciated.
Thanks,
Rhett

[darkyam]

=IF('Analyst 1'!B3=Master!B3,IF('Analyst 1'!B3=0,"","Correct"),IF('Analyst 1'!=0,"Missed PoL",If(Master!B3=0,"Extra PoL","Incorrect")))

[Rhettvb]

Dear Forum Guru,

This is sooo close, but its not quite right. Perhaps my criterion above are not exactly correct.

With the formula you provided, when the "Master" is blank and the "Analyst 1" is correctly left blank the response "correct" appears in the cell. However, I'd like it to just stay blank. I only want the "correct" to come up when the Master has selected an option and the Analyst 1 also selects that option correctly. What do you think?

Thank you so much, this has been very frustrating (but in a good way, I guess).

[darkyam]

Ok, try =IF('Analyst 1'!B3=Master!B3,IF('Master!B3="","",IF('Analyst 1'!B3=0,"","Correct"),IF('Analyst 1'!=0,"Missed PoL",If(Master!B3=0,"Extra PoL","Incorrect"))))

If Master b3 is blank and analyst 1 is blank or 0, it will remain blank. If both need to be blank for it to remain blank, try
=IF(AND('Analyst 1'!B3="",Master!B3=""),"",IF('Analyst 1'!B3=Master!B3,IF('Analyst 1'!B3=0,"","Correct"),IF('Analyst 1'!=0,"Missed PoL",If(Master!B3=0,"Extra PoL","Incorrect"))))