Support Board
Date/Time: Mon, 21 Apr 2025 16:40:56 +0000
Post From: Support for Logical operators (+/*) for AND/OR
| [2025-02-25 16:04:44] |
| C_Money - Posts: 80 |
|
Do spreadsheet systems support logical operators for boolean evaluations? Are there any performance savings comparing the two methods below? // Column 1 (Logical Operators): = (ID0.SG1@3 > 100) * (ID0.SG2@3 < 50)
// Column 2 (AND() Function): = AND(ID0.SG1@3 > 100, ID0.SG2@3 < 50)
I've been trying to find a "best practices" or "performance considerations" page on this type of stuff but I'm unable. I have nested if's, or's, and and's all over the place and I'd like to consolidate them in to simpler lines of code. |