Combination

[piethein123]

Hi,
Hope someone can help with the following ;
need to make a nesting with 'if' of 'countif' and 'search'

so if it finds a value >0 with the countif it needs to say 'yes' , but also when it finds a specific word in a text and the place number of that text is also >0 it also needs to say 'yes' - otherwise 'no'

When i perform them seperately they work fine , but when i try to nest it will only give the outcome of 1 of the 2
can someone help?

i have belownow - but doesn't work. also if someone know a better way of search formula i'm open.
=if(or((search("word";J2))>0;countif('J:J;L2)>0);"YES";"NO")

 

[etaf]

=if(or((search("word";J2))>0;countif('J:J;L2)>0);"YES";"NO")

=if( OR ( ISNUMBER(search("word";J2));countif('J:J;L2)>0);"YES";"NO")

 

[piethein123]

wow that was fast , and it worked thanks so much

 

[etaf]

you are welcome