IFS2 function

The IFS2 function allows to check one value against multiple conditions.

IFS(value_to_check, condition_1, value_if_true_1, condition_2, value_if_true_2 ...)

When one of the conditions is met (condition_1, condition_2, etc), its corresponding value is returned

IFS( @NumberField, "<3", 100, 3, 300, ">3", 400 )

will return 300, When @NumberField is 3.

Need Help?
Can't find the answer in the help docs? We are quick to answer and friendly :) Thanks! We'll be back with a reply soon.