Forum Discussion
lastcynics98
Aug 04, 2025Copper Contributor
Logical function (AND, OR) in Dynamic Array/Spilled Range
Hello, I have a spilled function, (lets say in C1 I use SORT(B1:B10)) and I need to know if each cell in the spilled range is in the between a max value and min value, so I need the returned produ...
SergeiBaklan
Aug 05, 2025Diamond Contributor
In general, it's better to avoid AND() and OR() and use * and + instead.