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" <(E-Mail Removed)> wrote in message
news:ONCF%(E-Mail Removed)...
> 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 (1>2>3) 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" <(E-Mail Removed)> wrote in message
> news:ONCF%(E-Mail Removed)...
> > 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 (1>2>3) 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" <(E-Mail Removed)> wrote in message
> news:ONCF%(E-Mail Removed)...
> > 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 (1>2>3) evaluates to TRUE, though it would seem to be
> false.
>
> K
>
>

On Mar 16, 6:07*am, "KRK" <tre...@yeleek.nospam.freeserve.co.uk>
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 (1>2>3) 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 1>2>3 return TRUE ?.

1>2 is FALSE,

giving FALSE>3

= TRUE ?????

why is FALSE>3 True ?

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

K


"Shane Devenshire" <(E-Mail Removed)> wrote in message
news:9F6C6B89-5CEB-4733-9FCA-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:ONCF%(E-Mail Removed)...
>> > 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 (1>2>3) 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" <(E-Mail Removed)> wrote in message
news:044f3b69-d4a1-4b5c-aa43-(E-Mail Removed)...
On Mar 16, 6:07 am, "KRK" <tre...@yeleek.nospam.freeserve.co.uk>
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 (1>2>3) 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" <tre...@yeleek.nospam.freeserve.co.uk>
wrote:
> why does 1>2>3 return TRUE ?.
> 1>2 is FALSE, giving FALSE>3
> = TRUE ?????
> why is FALSE>3 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.
--(A1>A2)), 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 TRUE>FALSE, FALSE<TRUE, TRUE=TRUE and
FALSE=FALSE are TRUE.

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