Support > Repository > Function > Conditional branch
ja | en

Here are five functions related to conditional branching processing.

AND |  IF |  N |  NOT |  OR

AND (expression ...)

Perform an AND operation on the conditional expression of the argument.When all "expressions" are true, the result of the AND operation returns true.Since the return type is a boolean value (true or false)IF functionYou can use it inside of.

AND (Expression 1, Expression 2, Expression 3, ...)

An example Behavior
IF(AND(${x}>0, ${y}>0), "Yes", "No") (If both X and Y values ​​are greater than 0, the "Yes" character is set.)

IF (Conditional expression, when conditional expression is true, if conditional expression is false)

Judge whether the conditional expression is satisfied (true) or not (false). The symbols (comparison operators) used for conditional expressions are as follows.Please note that it is not exactly the same as Excel.

Description Description
X==Y X and Y are equal
X>Y X is greater than Y
X<Y X is smaller than Y
X>=Y If X is Y or more
X<=Y X is less than or equal to Y
X!=Y X and Y are not equal
!X Negation of X (If X is true, it is false)
X==null X is not yet input.
The notation null can only be used with character type or date/time/date/time type.

There is no limit on the number of combinations of IF functions.

IF (expression, $ {value 1}, $ {value 2})
IF (expression, IF (expression, $ {value 1}, $ {value 2}), $ {value 3})

An example Behavior
>= 80, "Target Achievement", "Not Reached") (If the score value is 80 or more, the word "goal achievement" is set.)
IF (EXACT ($ {str1}, $ {str2}), "same", "different") (For comparison of character strings,EXACT functionPlease combine.)
The operation result of "conditional expression true" and "conditional expression false" in the IF function is the type of the item describing the expression.

N (value)

Converts the argument's value to a number.

N(${item1})

An example Behavior
N (number) Numerical value
N (date) Serial value
N(true) 1
N(false) 0
N (Other) 0

NOT (expression ...)

Invert the boolean value of the argument. The type of the return value is a boolean value (true or false).

NOT (expression)

An example Behavior
NOT(ISBLANK(${x})) (If X is blank, false is returned.)

OR (expression ...)

Perform an OR operation on the conditional expression of the argument.When any "expression" is true, the result of the OR operation returns true.Since the return type is a boolean value (true or false)IF functionYou can use it inside of.

OR (Equation 1, Equation 2, Equation 3, ...)

An example Behavior
IF(OR(${x}>0, ${y}>0), "Yes", "No") (If either one of the X and Y values ​​is greater than 0, the "Yes" character is set.)