...

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

  • The “Condition to check” is “(14 - 7) > 0”

  • The “Value if TRUE” is “DateDiff(’today’, ‘yesterday’, 'h')” which is 24

  • The “Value if FALSE” is “50 / 2” which is 25

  • Since (14 - 7) > 0 is TRUE, the value assigned to the Calculated Field Question will be 24
    

• Iff([RadioQ1] > 0, [RadioQ1] < 3, FALSE)

  • The Condition “Condition to check check” is “[RadioQ1] > 0”

  • The Value “Value if TRUE TRUE” is “[RadioQ1] < 3” which will be TRUE/FALSE depending on the value of [RadioQ1]

  • The Value “Value if FALSE FALSE” is “FALSE”

  • The table below will show what the Calculated Field Question value will be based on the value of [RadioQ1]

...

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

  • The above 'Iff' formula will evaluate if the condition “Condition to check” is “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 “Value if TRUE” is 1

  • The “Value if FALSE” is 0

  • If the participant included option value 2 in checkbox question [QuestionOne], then the “Condition to check” equates to TRUE and the “Value if TRUE” will be assigned to the Calculated Field Question, which is 1.

  • If the participant didn’t include option value 2 in checkbox question [QuestionOne], then the “Condition to check” equates to FALSE and the “Value if FALSE” will be assigned to the Calculated Field Question, which is 0.

...