Multi Condition Statement to Set a Variable

[hubnerj]

I am looking to create a variable called DIFF that is set to a specific number based on the value of a text string called STATUS.  Basically - 

If STATUS=Submitted then DIFF=14

or

If STATUS=Active then DIFF=21

or

If STATUS=OnHold then DIFF=28

What would be the syntax for this?  Thanks in advance.

[Deku · Accepted solution]

Var diff =

Switch( 

Selectedvalue( table[status] ),

"Submitted", 14,

"Active", 21,

"On hold", 28

)

[Deku · Accepted solution]

Var diff =

Switch( 

Selectedvalue( table[status] ),

"Submitted", 14,

"Active", 21,

"On hold", 28

)

[hubnerj · Accepted solution]

Worked great, thanks!