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), it can be used inside the IF function.
AND(式1, 式2, 式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.) |
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(式, ${value1}, ${value2}) IF(式, IF (式, ${value1}, ${value2}), ${value3})
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.) |
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 |
Invert the boolean value of the argument. The type of the return value is a boolean value (true or false).
NOT(式)
An example | Behavior |
---|---|
NOT(ISBLANK(${x})) | (If X is blank, false is returned.) |
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), it can be used inside the IF function.
OR(式1, 式2, 式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.) |