Shane,

OK thanks but...In that case 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 ??

K


"Shane Devenshire" wrote in message
...
Hi,

Here is what is going on:

Suppose =1<2<3 is your formula

Excel starts on the left and evaluates 1<2 which is TRUE, next it
evalueates
TRUE<3 and returns FALSE. It never evaluates 2<3 in this example.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"KRK" wrote:


"KRK" wrote in message
...
Hello,

What does the logical expression (A1<A2<A3<A4) return ?

How is the expression evaluated ?

I've tried various numbers in A1....A4, but cannot seem to make sense
of
what the expression is doing ?


Thanks

KK


For example, the expression (1<2<3) evaluates to FALSE (though it would
appear to be true, and (123) evaluates to TRUE, though it would seem to
be
false.

K

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.