Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Intervals as logical statements
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. -- xnadeau ------------------------------------------------------------------------ xnadeau's Profile: http://www.excelforum.com/member.php...o&userid=28335 View this thread: http://www.excelforum.com/showthread...hreadid=479146 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Logical ELSE statements | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
Logical Function - Multiple IF statements | Excel Worksheet Functions |