IF THEN ELSE ENDIF Formula

[TonyNeari1304]

If [Customer] = "JV Pools & Spas, Inc.  (Bill Direct)" OR "United Aqua Group - JV Pools & Spas, Inc" THEN "Combo2" ELSE "" ENDIF

Trying to create a new column that puts an indicator for specific customers, but it only places the indicator for the first customer.  Any thoughts on how I can get the indicator for both customer names? 

[geraldo · Accepted solution]

@TonyNeari1304 

If [Customer] = "JV Pools & Spas, Inc. (Bill Direct)" OR [Customer] = "United Aqua Group - JV Pools & Spas, Inc" THEN "Combo2" ELSE "" ENDIF

[apathetichell]

hypothetically if yo uhave enough ors to get this to be uweildy - you can bunch them together using an instatement where each term is seperated by a comma.

If [Cusotmer] in ("Jv Pools & Spas, Inc. (Bill Direct)","United Aquia Group - JV Pools & Spas, Inc") then "Combo2" else "" endif 

[TonyNeari1304]

Thank you for the help on this!