https://bugs.documentfoundation.org/show_bug.cgi?id=174180
--- Comment #16 from Z <[email protected]> --- (In reply to Werner Tietz from comment #14) > (In reply to Z from comment #11) > > > =LET(a;A1;b;1/a;if(a=0;0;b)) —> resulted in a value of 0 in v26.8.1.1, but > > returns #DIV/0! in the Dev. > ``` > =LET(a;A1;b;IFERROR(1/a;0);b) #catch early! > > so far, I miss a fairly simple example where you MUST use, **nested** LET's Why do you even use LET and IFERROR? =IF(A1=0;0;1/A1) I mean, silly examples made to show a point are just that: silly examples made to show a point. The point here is the unexpected result. The expected response is either: • a correction of what causes the unexpected result, or... • an explanation that discusses technical issues that will force the unexpected result for the foreseeable future, or... • an explanation that the issue is deemed less critical than other issues, and is being shelved for now. But the dismissal of the issue, based on easy workarounds for the minimalistic example provided that still results in a problem, that is beside the point. -- You are receiving this mail because: You are the assignee for the bug.
