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