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...
Patrick2788
Aug 04, 2025Silver Contributor
Try this one:
=IF((C1#>=3000)*(C1#<=7000),"Normal","Abnormal")
Jalessa
Aug 05, 2025Iron Contributor
Yes I experienced the same issue, I noticed I had to return a spilled array of results, so I used the element-wise logical operations with the * ( for AND) or + ( for OR ) operators.