<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - [1] IFS function mishandles valid #N/A results from functions within IFS"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124710#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - [1] IFS function mishandles valid #N/A results from functions within IFS"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124710">bug 124710</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>Seems to be an error in error propagation..
Same with
=IFS( OR(I9="pago",I9="reci"), NA(), AND(I9="tran",E9>0),"FT from",
AND(I9="tran",E9<0), "FT to", 1, "no idea")
but not with
=IFS( 0, NA(), 0,"FT from", 0, "FT to", 1, "no idea")
where the result is "no idea".
Also
=IFS( OR(I9="pago",I9="reci"), NA(), 0,"FT from", 1, "no idea")
produces the expected result, but not
=IFS( OR(I9="pago",I9="reci"), NA(), 0+0,"FT from", 1, "no idea")
and also not
=IFS( OR(I9="pago",I9="reci"), NA(), 0,"FT from", 1+0, "no idea")
So whenever an expression is to be evaluated for the condition after a not to
be returned error result was encountered.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>