Question as to how I can combine these two CF conditions?

[suprsnipes]

Hi,

How can I combine these two CF conditions into 1.

1.

=OR(ISNUMBER(SEARCH("D",$J866)),ISNUMBER(SEARCH("V",$J866)))

2.

=AND($J$867="S",$I$867>$G$867)

Regards,
suprsnipes

 

[Andrew Poulsom]

Like this?

=AND($J$867="S",$I$867>$G$867,OR(ISNUMBER(SEARCH("D",$J866)),ISNUMBER(SEARCH("V",$J866))))

 

[MrKowz]

Try:

=OR(OR(ISNUMBER(SEARCH("D",$J866)),ISNUMBER(SEARCH("V",$J866))),AND($J$867="S",$I$867 > $G$867))

 

[suprsnipes]

Thanks for your help guys. I used the following;

Try:

=OR(OR(ISNUMBER(SEARCH("D",$J866)),ISNUMBER(SEARCH("V",$J866))),AND($J$867="S",$I$867 > $G$867))