how to do a nested if statement

A

analyst

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.
 
B

Bernard Liengme

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
 
D

David Biddulph

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

driller

i maybe confused..

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