What formula should I use to assign a value to column B depending on the value of column A? Column A data looks like this: 12345 23456 34567 If the first character of Column A is 1, Column B should show "Alpha" If the first character of Column A is 2, Column B should show "Beta" If the first character of Column A is 3, Column B should show "Gamma" What logic should I use here?

Reputation: 1

Excel Logic based Result

What formula should I use to assign a value to column B depending on the value of column A?

Column A data looks like this:

12345
23456
34567

What logic should I use here?

Upvotes: 0

Reputation: 2145

I would use the CHOOSE function here. In B1 place this formula:

=CHOOSE(LEFT(A1),"Alpha","Beta","Gamma")

Upvotes: 2

Reputation: 2192

In B you could have: IF(LEFT(A1;1)=1;"Alpha";IF(LEFT(A1;1)=2;"Beta";"Gamma"))

Upvotes: 0