| 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 |
|
#2
|
|||
|
|||
|
Intervals as logical statements
That is the syntax. What is wrong with conforming to the syntax?
-- HTH RP (remove nothere from the email address if mailing direct) "xnadeau" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
Intervals as logical statements
How about the logical function =AND(A2<=B2,B2<=C2) and drop the IF function completely? -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=479146 |
|
#4
|
|||
|
|||
|
Intervals as logical statements
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) "MrShorty" wrote in message ... How about the logical function =AND(A2<=B2,B2<=C2) and drop the IF function completely? -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=479146 |
| Reply |
| 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 | |||
Linear Mode
