The two main types of functions are as follows
- Functions that determine whether a value is True or False based on its numeric or textual status.
- Functions that create logical expressions from the judgment results.
Basically, the function that makes the judgment first is used to produce True or False, and then additional logical expressions are created as needed.
|equals||It compares the two values of the argument and determines True if they are the same and False if they are different.|
Functions to create logical expressions.
|if||This function changes the value returned depending on whether the result of the expression is True or False.|
It works similar to the IF function in Excel.
When multiple actions are to be executed depending on the result of the judgment, or when the actions to be executed are different, "Condition" is used, but if the actions are only different numbers or text, the if function is more appropriate in many cases because it is more concise.