Add to an IF statement

[edwardpestian]

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-$A15>90,-1,IF(MIN(IF($A16:$A25<TODAY(),IF($B16:$B25<>"BER",$A16:$A25),0))-$A15>90,-1,0)))}

Thanks.

ep

 

[Bearacade]

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

 

[edwardpestian]

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-$A15>90,-1,IF(MIN(IF($A16:$A25<TODAY(),IF(OR($B16:$B25<>"BER",$B16:$B25<>"IW",$A16:$A25),0))-$A15>90,-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