LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default How is "A1<=A2<=A3" evaluated?

How does Excel evaluate "A1<=A2<=A3"?

I assume Excel evaluates it as (A1<=A2)<=A3,
where "(A1<=A2)" results in the boolean value
TRUE or FALSE.

When I put =(A1<=A2) into C1 and =C1*2 into
C2, C2 is 2 when A1<=A2 and 0 when A1A2. So
I infer that TRUE=1 and FALSE=0 in a numerical
expression.

But =(A1<=A2)<=A3 always evaluates to FALSE,
and =A1<=(A2<=A3) always evaluates to TRUE,
no matter what numerical value I put into A3
(esp. 0) and what the relationship is between
A1 and A2.

The formula =(A1<=A2)<=A3 does behave as
expected if A3 is FALSE. That is, the formula
result is FALSE when A1A2, and it is TRUE
when A1<=A2.

But since =(A1<=A2)*2 has a numerical result
-- ergo, "(A1<=A2)" is treated as a number
sometimes -- shouldn't =(A1<=A2)<=A3 treat
"(A1<=A2)" as a number when A3 is a number?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum Count of Single Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 9 July 14th 05 10:01 PM
sumproduct bombs out JN Excel Worksheet Functions 15 July 11th 05 11:50 PM
the cell currently being evaluated contains a constant Barrie Wells Excel Worksheet Functions 2 June 2nd 05 12:59 PM
Can Excel represent formula in textural format with values substi. BoneR Excel Worksheet Functions 7 March 31st 05 03:11 PM


All times are GMT +1. The time now is 10:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"