Multiple IF Statement for Status Codes

[mbrawn]

Hi there,

I need to form the correct version of this IF statement. Or, more likely, a different statement with the same outcome!

If Status = 3 then "Won"

If Status = 4 then "Lost"

If Status = BLANK then "Open"

Below is the code I'm trying and the Blank part does not seem to recognise it should display as "Open".

Any help appreciated,

Thanks

Status = (IF(opportunities[statuscode] = 3, "Won", IF(opportunities[statuscode] = 4, "Lost", IF(opportunities[statuscode] = BLANK(), "Open"))))

[Eric_Zhang · Accepted solution]

@mbrawn

You could try

Status =
SWITCH (
    opportunities[statuscode],
    3, "Won",
    4, "Lost",
    BLANK (), "Open",
    "defaut value if doesn't in any prior case"
)