IF Statement - Correct Syntax help

[KC_1987]

Hi, 

Can anyone please help me with the correct syntax of my attempt below please? 

C_Depth =

if(TV[TUV]) = "New" , "TUV"

|| (TV[SBV]) = "New" , "SBV"

|| (TV[EWR]) = "New" , "EWR"

|| (TV[LC]) = "New" , "LC")

Thanks

[Mariusz · Accepted solution]

Hi @KC_1987 

Try Switch.

C_Depth = 
SWITCH(
    TRUE(),
    TV[TUV] = "New", "TUV",
    TV[SBV] = "New", "SBV",
    TV[EWR] = "New", "EWR",
    TV[LC] = "New", "LC"
)

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.