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 a better way.