I guess I wasn't clear. Rather than an AND statement it should be an OR
statement. In other words if B16:b25<"ber" OR "iw"
Unfortunately, when I add the OR statement, I do not get the expected
result.
=IF($A15=0,"",IF($A16-$A1590,-1,IF(MIN(IF($A16:$A25<TODAY(),IF(OR($B16:$B25<"BE R",$B16:$B25<"IW",$A16:$A25),0))-$A1590,-1,0)))
The original formula returns -1; however the above formula returns 0.
Shouldn't they both return the same value, as with the OR statement
only one criteria needs to be met?
ep
--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread:
http://www.excelforum.com/showthread...hreadid=552716