https://bugs.documentfoundation.org/show_bug.cgi?id=124710
forou...@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |forou...@gmail.com
--- Comment #1 from forou...@gmail.com ---
Created attachment 150721
--> https://bugs.documentfoundation.org/attachment.cgi?id=150721&action=edit
Small spreadsheet showing IFS working and malfunctioning.
In sheet 1 the highlighted #N/A values show where the IFS function mishandles a
valid #N/A result from a VLOOKUP. You will also see three rows where the
VLOOKUP found a match and the IFS formula worked.
Note that this spreadsheet was created in Excel 2016 where no such problem
exists; i.e. the #N/A result in Excel is treated as a FALSE and the following
conditions are evaluated until TRUE or the default is reached.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs