Description: I'm using the following formula "=IF(O($O16="";$P16="";$Q16="";$R16="";$S16="";$U16="");"";MAX($A$4:A15)+1)". Even if I don't change the values in the cells O16,P16,Q16,R16,S16 and U16 sometimes I see the correct value, other times I see the message "Err:522". It's completly random. Steps to Reproduce: 1.=IF(O($O16="";$P16="";$Q16="";$R16="";$S16="";$U16="");"";MAX($A$4:A15)+1) 2. 3. Actual Results: Err:522 Expected Results: a number Reproducible: Sometimes User Profile Reset: Yes Additional Info: I can give you a copy of my file ed the position where there is the formula
Created attachment 169094 [details] The problem is at the second sheet cells A16 and below. At the start the values is correct but try for example at change the value in cell O16 and you'll see that the value change in Err:522
Err:522 comes with circular references. file:///C:/Program%20Files/LibreOffice/help/en-US/text/scalc/05/02140000.html?DbPAR=CALC#bm_id3146797 'Formula refers directly or indirectly to itself and the Iterations option is not set under Tools - Options - LibreOffice Calc - Calculate.' You need to review your formulas to find why it happens. Maybe Menu/Tools/Detective/Trace errors, can help.
You were correct. It was my stupid mistake. I forgot a "$" in one of the cells. I'm sorry to have wasted your time. Ty very much Andrea
Closing as RESOLVED NOTABUG