If statement

[jrisebo]

If statement that only looks at first letter in cell.

I want to do an if statement, that if the first letter of a text string in a cell is "a", then it returns a value of 0 to a cell, and if "b", it returns a value of 1 to the cell.

Anyone ever done this?

Thanks

 

[villy]

Try:
[B1]=IF(LEFT(A1,1)="a",0,IF(LEFT(A1,1)="b",1,""))

 

[VoG]

Try

=IF(LEFT(A1,1)="a",0,IF(LEFT(A1,1)="b",1,""))

 

[jrisebo]

That did it!, thanks Gents!