|re: I tried the if statement in J2 with IF(I2>0;I2;;k2) and get err 504 .|
You have an extra semicolon in your formula. Perhaps that is causing the error.
re: ... I now have to re-enter that formula = J2 again to to cell K2. Once isn't bad but for the entire worksheet is.
I don't use Open Office, but in Excel you can "AutoFill" a formula to the bottom of a range by double clicking to AutoFill handle.
In other words, when you insert a new Column L, your existing Column L formulas will move to Column K. If you then enter a formula in the "new" L2, and then double click the AutoFill handle in the lower right corner of L2, Excel will copy that formula down to the bottom of the range adjacent to that cell (Column K).
For other methods of AutoFilling cells in Excel, see here:
I assume Open Office has similar AutoFill methods.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.