Skip to Content
Former Member
Dec 22, 2015 at 05:53 PM

How to join "If" statements


I have an if statement that works great:

=If([Lead ISM]) = "Auger" Then "Auger" ElseIf([BP: ISM]) = "Auger" Then "Auger" ElseIf([BP: ISM-2]) = "Auger" Then "Auger"

Auger is someone's last name, I have about 35 of these names and instead of creating them all individually, I would like to make this one dimension and include everyone.

What is the proper way to join these together, I have tested them all out individually and they return the correct data, but they are way off when I try to combine them all together, I feel like I am not joining them correctly.