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")
lastcynics98
Aug 05, 2025Copper Contributor
That works, thanks a lot!!