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

The reason for this is that the 'words' TRUE and FALSE are actually the numbers 1 and 0 in Excel (in most cases). So when you are creating the logical test in the IF function, you must treat it like a number i.e. no inverted commas.