gverhage wrote:=IF(K56>500;=SUM(K56-500);0) Gives ERR:510
Take out the "= " in front of SUM.
" = " is only used
when defining a formula in a cell where it tells Calc to treat what is typed as a formula and not as a text string.
SUM is a function and it does not require " = " in front of it.
That being said your use of SUM(K56-500) is extremely non standard - you are saying "add the following numbers, where Number 1 is (K56-500), and there are no Number 2, Number 3 etc", so you are not adding any numbers! Note that in SUM(x;y;z) the numbers to be added
must be separated by semi-colons. The simplest form of the formula is therefore =IF(K56>500;(K56-500);0) where the brackets round (K56-500) are advisable for clarity but not mandatory.
You will find much useful information in the
User Guides, the
Writer, Base and Calc Tutorials and the
AOO Frequently Asked Questions. May I suggest you bookmark the pages.
Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your
first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.