Ask Your Question
0

Error 522 in Libre Office Calc when using IF function [closed]

asked 2014-10-10 09:59:25 +0200

thanos gravatar image

updated 2016-03-04 20:08:20 +0200

Alex Kemp gravatar image

I am trying to do the following simple task. I have a two column with possitive and negative numbers. I want all negative numbers to be equal to 0. So I am using in the 1st cell (E1 that is) the following "code"

=IF(E1<0, 0, E1)

I also tried with semicolumn instead of comma but in either way I get a 522 error. What am I doing wrong?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-04 20:08:30.724234

1 Answer

Sort by » oldest newest most voted
0

answered 2014-10-10 10:06:17 +0200

lactea gravatar image

updated 2014-10-10 10:08:36 +0200

From the help file, Error 522:

Formula refers directly or indirectly to itself and the Iterations option is not set under Tools - Options - LibreOffice Calc - Calculate.

Are your calculations, by any chance, point back to the cell your are having the IF-function in? Or are your numbers in a separate column, say D, only?

edit flag offensive delete link more

Comments

Thank you very much for your answer! I am using the aforementioned code, on E1 cell. So I be;ieve that this is the problem...

thanos gravatar imagethanos ( 2014-10-10 10:08:46 +0200 )edit

I suggest enter the formula in another column. I always like to keep data and formulas separated.

lactea gravatar imagelactea ( 2014-10-10 10:11:52 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-10-10 09:59:25 +0200

Seen: 3,681 times

Last updated: Oct 10 '14