finding text in a cell

S

StarTrek an beyond

This formula works =IF(E10="x",1,"")+IF(E11="x",1,"") to add the two 1's to
make two.

I would like to change the "x" to just finding TEXT

I tried =IF(B15="txt",1,3) but I get the 3 instead of the 1.

Thanks
 
S

StarTrek an beyond

Thanks Don, I could not remember it, used it toooooo many years ago.

Wayne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section and Page numbering 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Extract Text in braquet and list of terms from 2 Docs 3
Payment calculation 1
Style Header Reformatted 3
Using FIND to highlight text (with dashes) 4
Select Text to End of Footnote 9

Top