https://bugs.documentfoundation.org/show_bug.cgi?id=171017
m_a_riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |rg --- Comment #14 from m_a_riosv <[email protected]> --- IPOV, the issue with the array formula: {=IF($Z3=0; 0; INDEX($A$2:$I$999; $Z3; {3|4|5|6|7|8|9}))} Is about INDEX not being calculate when Z3=0, so no bug there, IMO, because only one '0' when the condition it's true. You can use: =IF($Z3=0; {0|0|0|0|0|0|0}; INDEX($A$2:$I$999; $Z3; {3|4|5|6|7|8|9})) Aslo, can be use a formula like: {=INDEX($A$2:$I$999; $Z3; {3|4|5|6|7|8|9})*($Z3>0)} It works fine for me because INDEX it's always calculated, what can be a performance issue. -- You are receiving this mail because: You are the assignee for the bug.
