On Mar 19, 4:45*am, "KRK"
wrote:
why does 123 return TRUE ?.
12 is FALSE, giving FALSE3
= TRUE ?????
why is FALSE3 True ?

Sorry I must be daft I don't understand. What are the
'number values' of TRUE and FALSE ??

If we convert the logic values TRUE and FALSE to numeric values (e.g.
--(A1A2)), we get 1 and 0 respectively.

But apparently, the reverse is not true. Try computing =(A1=FALSE)
and =(A1=TRUE), where A1 is any numeric or text value. The result is
always FALSE. And only TRUEFALSE, FALSE<TRUE, TRUE=TRUE and
FALSE=FALSE are TRUE.

Apparently, we can only meaningfully compare logic values with other
logic values.