When using "OR" and "AND" formula on 2 arrays of same sizes, the result is equivalent to : - the "OR" operator between [the result of "OR" operator between all cells of the 1st array] and [the result of "OR" operator between all cells of the 2nd array] - the "AND" operator between [the result of "AND" operator between all cells of the 1st array] and [the result of "AND" operator between all cells of the 2nd array] I would like array functions which provide the result of "OR" and "AND" between the elements of the 2 arrays which have the same position. The array result would be built as below : - row 1 and column 1 is the result of the cell function bewteen the cell at row 1 and column 1 of the 1st array and the row 1 and column 1 of the 2nd array, - ... - row R and column C is the result of the cell function bewteen the cell at row R and column C of the 1st array and the row R and column C of the 2nd array, - etc Currently, the work around I found is a painfull use of nested IF formulas on arrays.
In which kind of formula? can you provide an example? Since 4.0 BITOR, BITAND and BITXOR are available and I think they can do what you expect of OR & AND.
Created attachment 112055 [details] truth table of current and expected OR and AND formulas The feature I need is currently implemented with IF formula. If I have more than 2 arguments, the IF are nested and that isn't easily readable. Moreover, it increases the size of the formula to be parsed.
AND/OR works like LO Calc with any spreadsheet software and it is expected: These functions expect scaler or range arguments like many other functions. For example =SUM(array1 ; array2) adds alls value even in array formula. And this cannot be change because it would not be possible to pass arguments to the function with another array formula. Just replaces AND & OR by BITAND & BITOR and you will have expected result. Note that these formula are showing 1/0 as result. You can format cells as Boolean if you need to see TRUE/FALSE.
Thanks. I will use BITOR and BITAND when my office will update our libreoffice to the 4 version.