Forum Discussion
Unable to use a nested IF(AND) function in an array function (Discussion)
Hello there! I came across the following discussion on the community: https://techcommunity.microsoft.com/t5/excel/two-wrongs-don-t-make-a-right-negative-worker-values-are-turning/m-p/4114539 ...
AND does not return an array of TRUE/FALSE values, but a single TRUE/FALSE value.
(logic1)*(logic2) returns an array of 1/0 values.
AND does not return an array of TRUE/FALSE values, but a single TRUE/FALSE value.
(logic1)*(logic2) returns an array of 1/0 values.
