Support Board
Date/Time: Mon, 21 Apr 2025 16:10:14 +0000
Post From: Support for Logical operators (+/*) for AND/OR
| [2025-02-27 01:10:11] |
| Jeffrey - Posts: 2248 |
|
Do spreadsheet systems support logical operators for boolean evaluations?
Boolean values are treated the same as numbers, where TRUE is the same as 1 and FALSE is the same as 0. Using the multiply operator (*) on two Boolean values is the same as multiplying two numbers. Incidentally, this multiplication does have the same results as an AND operation when used with Boolean values.Are there any performance savings comparing the two methods below?
I ran some performance tests using the two methods you provided. The results depended on the exact test setup. In some cases using AND was faster, and in other cases using the multiply operator was faster. But in most cases the difference was less than 1 percent. So there is no clear performance advantage to using one method over the other.
|