[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

lookup with "IF" condition

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
Ladkisson
Asked:
Ladkisson
1 Solution
 
GeisrudSystems AdministratorCommented:
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
 
LadkissonAuthor Commented:
Wonderful! Thanks!!
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Tackle projects and never again get stuck behind a technical roadblock.
Join Now