Account number is in column A
b1=if(len(a1)=11,"CBS","BOS")
Change the cell range accordingly
Best wishes
Sreedhar

"Nkumar" wrote:

In a worksheet I have two types of account numbers. One having eleven digits
and other having less than elelven digits. I have to insert a function to
get "CBS" in the next cell right to the account number having eleven digits
and "BOS" against the other account numbers. Please help me as I am an
intermediate in this works