https://bugs.documentfoundation.org/show_bug.cgi?id=171379
--- Comment #10 from Regina Henschel <[email protected]> --- (In reply to m_a_riosv from comment #9) > Created attachment 206287 [details] > Sample with more analisys > > ISBLANK() gives FALSE for the whole array range. That is expected, because the cells contain a formula and thus they are not empty. > ISNUMBER() gives TRUE only for the cells with value in the array range. That seems to be wrong. CELL("TYPE",C3) returns "v". ISTEXT() gives FALSE for all cells in the range C3:C12. What result can it be if all ISBLANK(C3), ISNUMBER(C3) and ISTEXT(C3) give FALSE? Unfortunately TYPE(C3) cannot be used for comparison because of bug 73085. > =C3=0 and =C3="", both gives TRUE for the empty cells in the array range. That should not happen. You get a similar ambiguity when you use XLOOKUP =ROW(0;XLOOKUP(;C3:C12;C3:C12)) results row 3 =ROW("";XLOOKUP(;C3:C12;C3:C12)) results row 3 On the other hand EXACT("";C3) gives FALSE. > > So why functions like AVERGE() take in account those cells while ISNUMBER() > not. For me it is a bug in the way empty cells are used in an assignment in array context. Therefore this bug report. -- You are receiving this mail because: You are the assignee for the bug.
