'Expected 'End' to match 'IF' at character 0

CODE

Whats is the issue with my calculated field here? Thank you in advance!



Solution 1:[1]

Wrong type of closing brace for [SEM Cost] after the third THEN

You could simplify by combining the second and third cases since they lead to the same result, and could also remove some unnecessary parentheses

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Alex Blakemore