Solved

lookup with "IF" condition

Posted on 2013-12-18
2
187 Views
Last Modified: 2013-12-18
Hello!

I have a column with numbers. Some of them have 0 as a starting digit and some don't have "0" in front. I need to identify those that don't have zero. For example, if A1 has "0", then "Option A", if there is no "0" then "Option B"

Thanks
0
Comment
Question by:Ladkisson
2 Comments
 
LVL 14

Accepted Solution

by:
Geisrud earned 300 total points
ID: 39727229
The following formula checks if cell A1 begins with a 0.  If it does, then performs your "Option A", otherwise it performs your "Option B"

=IF(LEFT(A1)="0","Option A","Option B")
0
 

Author Closing Comment

by:Ladkisson
ID: 39727242
Wonderful! Thanks!!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

This article will show you how to use shortcut menus in the Access run-time environment.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

777 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