How do I create an 'if' formula to recognize one letter in a string of letters?
Posted on 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: