MS Excel TRUE FALSE Formula Not Returning Expected Result

Question

See formula in formula bar. I would expect this to return TRUE. Instead it returns FALSE.

Also see Formula Evaluation at stage before returning FALSE.

I am on Automatic Calculation.

I can't tell if it's a Formatting discrepancy. There are no apostrophes or spaces before or after the values.

Help needed.

Answer 1

There are two main reasons you might see a formula instead of a result: You accidentally enabled Show Formulas. Excel thinks your formula is text.