IF

The following section describes the syntax and usage of the IF function in ActivityInfo.

Description

The IF function is used to return a certain value if a specified condition is true, and return another value if the condition is false.

Syntax

IF(condition, trueReturn, falseReturn)

Argument Required Description
condition Yes The condition you wish to test.

The condition must evaluate to TRUE or FALSE.
trueReturn Yes The value you wish to return if the condition is true.
falseReturn No The value you wish to return if the condition is false.

Result

  • The trueReturn value if the condition evaluates to TRUE.
  • The falseReturn value if the condition evaluates to FALSE.
  • NA if the condition is not a logical value (TRUE/FALSE).
  • #VALUE! if all required arguments have not been provided.

Example

We will be using the IF function to evaluate a condition and return different values for a TRUE and FALSE case.

Arguments

We will be using the Multiple Selection Field "Against what have you been vaccinated?" with Field code "VAC".

Formula

IF(VAC.Measles,1,0)

Results