IFS2 function

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

IFS2(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

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

will return 300, When @NumberField is 3.

Need Help?
Already checked the help docs? We're quick to answer and friendly
We'll reply very soon at
Send message