If statement multiple lookups

[drluke]

I want to change the formula below to give me the left 3 numbers if col A has a 6 instead of 5 digit code in it, but still return the left 2 only if there is a 5 digit code in col A

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Col A[/TD]
[TD]Col B[/TD]
[/TR]
[TR]
[TD]15035[/TD]
[TD]=IF(A1="5522",50,LEFT(A1,2))[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

Hi, can it only ever be a 5 or 6 digit code?

If so, one option..:

=IF(A1="5522",50,LEFT(A1,LEN(A1)-3))