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
Texts and Booleans are always "more than" any number. Something like
=--TRUE > 1
=1*TRUE > 1will return false.
Thank you for your answer first,
You are correct that Boolean and text are always greater than numbers
If Boolean is compared to text, whether Boolean is always larger than text, I have found this to be the case in use
thank you
You are welcome