Intervals as logical statements

X

xnadeau

I'm trying to get Excel to determine whether x<=y<=z is true or false
but it always comes up false when written this way (even if x=1, y=2
and z=3). I finally ended up with a formula that looked like this
=if((and(a2<=b2,b2<=c2)),d2,b2). This worked, but there must be
better way
 
B

Bob Phillips

That is the syntax. What is wrong with conforming to the syntax?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
M

MrShorty

How about the logical function =AND(A2<=B2,B2<=C2) and drop the I
function completely
 
B

Bob Phillips

It gives a different result, TRUE or FALSE, not what is in B2 or D2

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top