IF Statement Evaluates as "TRUE" but Returns "FALSE" Value (Excel 2007)

I have a large Excel 2007 project I am working on in which I need to determine unique values from linked data that may contain no information, unique information, or duplicate information. My formula is behaving very oddly, and causing problems.

The odd behavior is that, although the logical argument returns a "TRUE" result, the IF statement I am using is calculating and displaying the [value if false] results.

If I click on a cell where the incorrect value is returned, and use F9 to evaluate sections of the formula at a time, the logical argument behaves correctly. Also, the [value if true] argument, when highlighted and evaluated separately (using F9), generates the correct value. In fact, if I highlight the entire formula and press F9, the correct value is returned! HOWEVER, when I just allow the formula to do it's thing, the incorrect data is displayed...

I have attached a sample spreadsheet which shows the issue: Example Sheet for Formula Troubleshooting.xlsx

VBA is NOT an option for this project.

Wow - I knew it had to be something simple. (I was unaware MIN was a CSE formula - that's good to know...) Using CTRL+Shift+Enter took care of it! Thank you very much!