worksheet functions

N

Nkumar

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
 
Y

yshridhar

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

Stefi

What are CBS and BOS and what are the rules to generate them. It's not
obvious for everybody?

Regards,
Stefi

„Nkumar†ezt írta:
 
J

Jarek Kujawa

....and what is the format of account numbers?
if it's a straight number then maybe the following would suit better:
b1=if(and(isnumber(a1),len(a1)=11),"CBS","BOS")
 
S

Stefi

Well, I see now that they are simple strings.
Stefi


„yshridhar†ezt írta:
 

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

Excel - Wich Function should I use? 1
LOOKUP function help 6
Multiple formats in one cell 1
find and replace numeric strings in larger text strings 8
Adding recognised Zeros 5
Count Blank Cells with Conditions 3
search function 2
Page numbering with Merged Document and IF statements 1

Top