Add to an IF statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

edwardpestian - 16 Jun 2006 17:06 GMT

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

Signature

edwardpestian

Reply to this Message

Bearacade - 16 Jun 2006 17:43 GMT

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

Signature

Bearacade

Reply to this Message

edwardpestian - 16 Jun 2006 17:59 GMT

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

Signature

edwardpestian

Reply to this Message