Forum Discussion
Why " =TRUE>1" is TRUE
In Excel, I enter the expression "=TRUE > 1" and the result is TRUE, I don't know why? There seem to be some rules, but I can't find any documentation
What is the use case for this?
I looks like Excel is converting the data type from logical to text before doing the comparison.
Try N(TRUE)>1.