if function to produce a value

[jarett]

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.

[cbatrody]

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","")

[bhenlee]

try:

=IF(VALUE(RIGHT(LEFT(A1,12),2))=10,"down")

[José Augusto]

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

[ThirdFret]

The following formula should also work:

Please Login or Register  to view this content.

[José Augusto]

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

[jarett]

Thanks everyone awesome it works

[cbatrody]

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.