how to do a nested if statement
 

I am looking at values in one column to see if they start with specific 2 or
3 char. then I want to have a result value of 1 of three words. I.E., if the
value contains ab at the beginning then the result in the next column will be
AB, if the value contains abc at the beginning then the result will be abc,
if the value contains def in the beginning then I want the result to be def.
I tried using 3 if statements. That did not work.

how to do a nested if statement
 

It would seem you must look at the three characters first. Have you given us
all the things to look for? Are they just: abc, ab and def
=IF(LEFT(A1,3)="abc","ABC",IF(Left(A1,2)="AB","AB" ,IF(LEFT(A1,3)="DEF","DEF","Not
there")))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"analyst" wrote in message
...
I am looking at values in one column to see if they start with specific 2
or
3 char. then I want to have a result value of 1 of three words. I.E., if
the
value contains ab at the beginning then the result in the next column will
be
AB, if the value contains abc at the beginning then the result will be
abc,
if the value contains def in the beginning then I want the result to be
def.
I tried using 3 if statements. That did not work.

how to do a nested if statement
 

=IF(LEFT(A1,3)="abc","abc",IF(LEFT(A1,2)="ab","AB" ,IF(LEFT(A1,3)="def","def","none
of the above")))
--
David Biddulph

"analyst" wrote in message
...
I am looking at values in one column to see if they start with specific 2
or
3 char. then I want to have a result value of 1 of three words. I.E., if
the
value contains ab at the beginning then the result in the next column will
be
AB, if the value contains abc at the beginning then the result will be
abc,
if the value contains def in the beginning then I want the result to be
def.
I tried using 3 if statements. That did not work.

how to do a nested if statement
 

i maybe confused..

<<then I want to have a result value of 1 of three words. I.E.,

"analyst" wrote:

I am looking at values in one column to see if they start with specific 2 or
3 char. then I want to have a result value of 1 of three words. I.E., if the
value contains ab at the beginning then the result in the next column will be
AB, if the value contains abc at the beginning then the result will be abc,
if the value contains def in the beginning then I want the result to be def.
I tried using 3 if statements. That did not work.