Logical Functions

The table below summarizes each logical function, along with issues you may encounter when using them.

​

Function Overview

​

Introduction to Functions

Logical functions are a category of functions that return either the logical value true or the logical value false.

• true: Indicates that the result of the check is true or correct. It can also be represented by 1.
• false: Indicates that the result of the check is false or incorrect. It can also be represented by 0.

​

Common Scenarios

​

Block Form Submission When a Formula Is Met

Block form submission when the product name equals “Watermelon”. See the following example.

​

Requisition Quantity Cannot Exceed Stock Quantity

In business scenarios such as inventory management systems and product stock management, you often need to ensure that the requisition quantity does not exceed the stock quantity. See the following example.

​

Nested IF Functions

Below 60 is Fail; 60 to 89 is Average; 90 and above is Excellent. See the following example.