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?