if function to produce a value

I was wondering if I could produce an if statement where I could produce the word "down" if the 11th character = "10", how would the formula look?

BW1-10-R1-10-P05

Any help would be appreciated.

Hi,

Welcome to the forum.

If you have the text in A1 (BW1-10-R1-10-P05), try the following formula in B1:

=IF(1*MID(A1,11,2)=10,"down","")

Or try this
=IF(COUNTIF(M10,"??????????10*")=1,"Down","")

The following formula should also work:

Please Login or Register  to view this content.

Or try this
=IF(COUNTIF(M10,"??????????10*")=1,"Down","")

Thanks everyone awesome it works

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.