IF() statement

[gverhage]

I can't figure what is wrong with this IF statement

M26 reads

=IF(K56>500;=SUM(K56-500);0) Gives ERR:510

K56=1579.08

M26 should read 1079.08

Please look it over and let me know what I am doing wrong. Thanks

[RoryOF]

Why =Sum(K56-500)? Would not K56-500 be better?

[RusselB]

Experience with this type of problem leads me to believe it's due to the second = sign in the formula.
I don't know why OpenOffice doesn't like seeing more than one = sign in a single formula, but it doesn't.
I also agree with Rory about using the simpler K6-500.
So, I'm suggesting using

Code: Select all

=if(K56>500;K56-500;0)

[John_Ha]

=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.