View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default 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