Solved

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

Posted on 2012-03-20
2
285 Views
Last Modified: 2012-03-20
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.
0
Comment
Question by:jag4
2 Comments
 
LVL 7

Accepted Solution

by:
micropc1 earned 500 total points
ID: 37743259
=IF(LEFT(cell, 1)="B", "Y", "N")
0
 

Author Closing Comment

by:jag4
ID: 37743279
Quick, simple, perfect. Thanks!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question