How do I create an 'if' formula to recognize one letter in a string of letters?

What 'if' function can I make to give me a "Y" or "N" if that account card starts with "B"?

When an account code starts with the letter "B", no matter what numbers/letters follow the code, this project will be charged to the department. All other costs with all other codes will be charged elsewhere.

The account codes are all structured the same:  

A.BC.123456.7890
G.HI.098765.4321

Thanks.
jag4Asked:
Who is Participating?
 
micropc1Commented:
=IF(LEFT(cell, 1)="B", "Y", "N")
0
 
jag4Author Commented:
Quick, simple, perfect. Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.