This simple IF statement has me baffled.

=IF(K13>=E27,K12)

1,000,000 is typed in the green enter box and the result is year 2019. But in 2019 the Net Worth total is $465,724.80. So, why does this formula render the year 2019?

Curious too, is that if this equation is alone, and not a nested IF statement, it returns a FALSE, as expected. So, why when it is in the group, as a nested IF statement, does it not return a FALSE? If it returned a FALSE, then the entire equation would move along until it found a match.
1,000,000 formula.xlsx