» Determining Long Distance Phone Calls, Based on the Number Dialed
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Column A lists the numbers dialed for all phone calls made on a particular day.
All numbers starting with "1", except for those starting with "1800", are for long distance calls
We want to analyze each number in column A and determine whether or not it was used for a long distance call.
Solution:
Use the IF, AND, LEFT, and MID functions as shown in the following formula:
=IF(AND(LEFT(A2,1)="1", MID(A2,2,3)<>"800"),"Long Distance", "Not Long Distance")
Book Store:
Recommended Books:
- Financial Reporting and Analysis (2nd Edition)
- Absolute Beginner's Guide to Microsoft Excel 2002
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Keys to Reading an Annual Report (Barron's Business Keys)
No comments have been submitted.
