I have the following IF statement working, but I'd like to add another
criteria to the second IF statement withing the MIN function. For
example: IF($B16:$B25< "BER" *and* "IW"

Can I do this without adding another IF statement?

{=IF($A15=0,"",IF($A16-$A1590,-1,IF(MIN(IF($A16:$A25<TODAY(),IF($B16:$B25<"BER", $A16:$A25),0))-$A1590,-1,0)))}

Thanks.

ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=552716