Overview
If any parameter logical value is TRUE, the function will return TRUE. Only when all parameter logical values are FALSE will the function return FALSE.
Syntax | OR(Logical1,Logical2,...) | If all parameter values are false, returns 0. If any parameter value is true, returns 1. |
Parameter 1 | Logical1,Logical2,... | Parameter |
Notes
The parameter must be of the boolean type or numerical type.
For true(TRUE) and false(FALSE) in the parameter, both capital and lowercase are supported and marked in blue.
Example
Use Payback Amount and Contract Amount in the sample data. Filter products with the contract amount larger than 500,000 or payback amount larger than 100,000.
Use the Filter function. Click Filter, click the dropdown icon of Add Formula, and select OR Formula. Click Please Edit Formula, enter OR(Contract Amount > 500000,Payback Amount > 100000) in the pop-up box, and click OK. The data that meets the condition is filtered, as shown in the following figure.
After the filter is completed, the following figure shows the effect.
The following table describes more examples.
Formula | Result | Note |
OR(1+7=9,5+7=11) | 0 | |
OR(1+7=8,5+7=11) | 1 |
