I use IF all the time on numerical things, and typically have it print our 111 if true, and 0 if false.

But I'm in a situation where I want to "search" an array of alpha text and make a decision, like =IF(D11=B,111,0) and of course you experienced folks know what happens.

So, not being thoroughly familiar with all the logical functions, and never using alpha text, I don't know how to go about writing a simple function to sort out all the "b's" that might be in my array.

Can I use "IF"? or should I be trying something else; note....... I'd have perhaps a 1000 rows of data, 20 colums, and want to examine [a row at a time is fine] and then print out a 111 in the 21st column if that row contained a "b".

thx,

LarryR