How can I modify this formula to include a condition where cell does not contain

[suprsnipes]

How can I edit the following formula so that instead of F64 being equal to "" I want to replace this condition to; if the cell F64 does not contain the letter "O". I've tried using isnumber but not quite sure how to use it when I'm looking for not equal to.

=IF(AND(F64="",C64<=4),SUM(-P64),"")

Regards,
suprsnipes

 

[jdmc45]

=if(and(f64<>0,c64<=4),sum(-p64),"")

 

[jdmc45]

sorry I thought it was for zero. Correct formula would be:

=IF(AND(F64<>"O",C64<=4),SUM(-P64),"")

 

[Roli001]

=if(and(f64<>"O",c64<=4),sum(-p64),"")

 

[T. Valko]

How can I edit the following formula so that instead of F64 being equal to "" I want to replace this condition to; if the cell F64 does not contain the letter "O". I've tried using isnumber but not quite sure how to use it when I'm looking for not equal to.

=IF(AND(F64="",C64<=4),SUM(-P64),"")

Regards,
suprsnipes

You don't need that SUM function.

=IF(AND(F64<>"O",C64<=4),-P64,"")

 

[suprsnipes]

I've come up with this which works. Not very clean.

=IF(C64<=4,IF(ISERROR(FIND("O",F64)),-P64,""),"")

The problem is with cell F64 it can meet a number of different conditions but I'm only looking for it not to equal just one of those.

The formula above will do for the time being.

Thanks for your help guys.