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

"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

You may be slightly backwards:
1<2<3
since clearly 2 is greater than 3 this is the same as:
1<1
which is false.

Since 1 cannot be less than either 0 or 1, this type of statement is ALWAYS
false.

--
Gary''s Student - gsnu200839


"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

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 16, 6:07*am, "KRK"
wrote:
What does the logical expression *(A1<A2<A3<A4) return ?
[....]
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.

I suspect the logical expression you want is:

AND(A1<A2,A2<A3,A3<A4)

Alternatively:

(A1<A2)*(A2<A3)*(A3<A4)

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

Hi, Thanks, yes I agree, that is where I started.

But I was surprised to find that the boolean (a1<a2<a3<a4) actually gives an
answer (rather than causing an error) and if I could understand how it
worked it might be a more elegant way of doing the job.

KK

"joeu2004" wrote in message
...
On Mar 16, 6:07 am, "KRK"
wrote:
What does the logical expression (A1<A2<A3<A4) return ?
[....]
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.

I suspect the logical expression you want is:

AND(A1<A2,A2<A3,A3<A4)

Alternatively:

(A1<A2)*(A2<A3)*(A3<A4)

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.