Forum Discussion
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...
Try this:
=IF(BYROW(C1#;LAMBDA(a;AND(a>3000;a<7000)));"Normal";"Abnormal")