...

• Iff((14 - 7) > 0, DateDiff('today', ‘yesterday', ‘h'), 50 / 2)

  • The above formula will evaluate if the condition “14 - 7 > 0” is true or false

  • If true, it will evaluate “DateDiff(’today’, ‘yesterday’, 'h')

  • If false, it will evaluate “50 / 2”
    

• Iff(ResponseExists([RadioQ1]), [RadioQ1] < 1, false)

  • The above formula will evaluate the condition “ResponseExists([RadioQ1])”

  • If true, “[RadioQ1] < 1” will be evaluated

  • If false, “false” will be evaluated
    

• Iff(Contains([QuestionOne], 2), 1, 0)

  • The above 'Iff' formula will evaluate if the condition “Contains([QuestionOne], 2)” is true or false

  • The 'Contains' formula will get the last response for the question “QuestionOne” and check if ‘2' was one of them. If ‘2’ was one of them the logic will return TRUE and if '2’ was not one of them the logic will return FALSE.

  • If true, it will evaluate “1”

  • If false, it will evaluate “0”

...

The ‘Contains’ formula is a TRUE/FALSE statement used to check if a particular option was selected in a checkbox question type. In CMS (platform v1), the way to do that is to write something like this: [checkboxq(value)] == 1. This has been changed up in V2. The new formula to check if a checkbox contains a specific value is:

...

• Contains([CheckboxQ1], 3)
  The formula will get the last response(s) for the question “CheckboxQ1” and check if ‘3' was one of them. If ‘3’ was one of them the logic will return TRUE and if '3’ was not one of them the logic will return FALSE.

...