Solved

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

Posted on 2012-03-20
2
283 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

758 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now