https://bugs.documentfoundation.org/show_bug.cgi?id=143395

Regina Henschel <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEEDINFO                    |RESOLVED

--- Comment #3 from Regina Henschel <[email protected]> ---
The cells in lines 150, 155, 395, 415, 420, 493, 680, 685 and 752 contain the
error value #N/A.
The function MAX cannot skip cells with error values, but propagate the error.

In case you will not remove the error values (find & replace), you can use the
formula =MAX(IFNA(L1:L825;"")). You need to enter it as matrix formula (Ctrl +
Shift + Enter).

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to