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

If(and($b16:b25<"ber", $b16:b25<"iw"),


--
Bearacade


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

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