IF THEN ELSE ENDIF Formula

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?

Best Practices

Accepted answers

geraldo

@TonyNeari1304

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

All comments

geraldo

@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!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335