https://bugs.documentfoundation.org/show_bug.cgi?id=124710
Winfried Donkers <winfrieddonk...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Assignee|libreoffice-b...@lists.free |winfrieddonkers@libreoffice
|desktop.org |.org
Status|NEW |ASSIGNED
--- Comment #9 from Winfried Donkers <winfrieddonk...@libreoffice.org> ---
The cause is clear now (the 'error' NA() is propagated on the stack, causing
incorrect results in certain cases), the solution too (redesign of the function
to jump-type).
I will give it a try, it will probably take time.
A workaround is to avoid using parameters that can give errors as result, i.e.
use references that have been tested not to contain an error value.
In the formula given in description, that would mean putting
VLOOKUP(J9,$local_vlookup.A:C,2,0) in an unused cell, e.g. Z9, as follows:
IFERROR( VLOOKUP(J9,$local_vlookup.A:C,2,0), "ERROR OCCURRED:) and replace the
formula by
=IFS(
OR(I9="pago",I9="reci"),Z9,
AND(I9="tran",E9>0),"FT from",
AND(I9="tran",E9<0),"FT to",
1,"no idea"
)
--
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
