If then else expression

[#1]

Hi,

Could someone please help to give me some guidance on how to create an if, then else expression.

I need an expression for the following:

If Priority = 1 or 2 and Initial response is <= 10 min then 1, else if Priority = 3 or 4 or 5 and initial response <= 4 hours then 1 else 0.

Appreciate your help with this.

[alexpanjhc · Accepted solution]

If ((Priority = 1 or Priority= 2) and [Initial response] <= 10 , 1,

if ((Priority = 3 or Priority= 4 or Priority= 5) and [initial response] <= 240, 1 , 0))

[#3]

Thanks this works!