SQL and Tableau both support a CASE function with the syntax
WHEN Condition 1 THEN Result 1
WHEN Condition 2 THEN Result 2 ...
WHEN Condition N THEN Result N
ELSE Default Result
I'm thrilled that I can now use this with the In-DB tools, but I'd love to have this available in the regular function tools so I can stop nesting my IFs!