[Solved] IF function result differs from Excel

[Oskar4U]

I have copied an Excel table to LibreOffice Calc 7.6.5.2 (x86_64) and I get incorrect results in a column where I have this function

=IF(F53=0,G52+E53,G52+F53)

Some times the results are correct and some times the results are not correct so I try to find out where the mistake is.

Since the function was copied from Excel I wonder if this functions syntax is correct or needs to be modified.

Thank you

[RoryOF]

Turn on /View /Value highlighting, and check the data types of the cells involved.

[Oskar4U]

Thank you for your time RoryOF

I did what you described and noticed the data related to the function are all highlighted. So I assume the syntax of the function is correct.

Much appreciated

[floris v]

Some times the results are correct and some times the results are not correct so I try to find out where the mistake is.

That's rather vague. Can you be more explicit? How are the results not correct?
The syntax is not strictly correct. Calc uses a semicolon (;) instead of a comma to separate parameters in functions, but LibreOffice seems to be forgiving with that, dependent on the settings in Tools - Options - Calc - Formula.

[Alex1]

Is the value in F53 the result of a calculation? Check if it's really zero by displaying more decimals.

[Oskar4U]

Sorry for the confusion, it is an accounting table for my yearly expenses:

G is the column where the final results is shown.
So if column F contains 0 it adds column E number to column G,
other wise it adds to column G what is in column F

=IF(F54=0,G53+E54,G53+F54)

The results are not correct because column G does not contain always the correct value

In Excel I used to copy the function from row 0 to row 500 and Excel used to change automatically the row numbers. I do not know if LibreOffice does the same.

As I mentioned perhaps I make a mistake and thinking the values are not correct so I went back to Excel. Now I will go back to LibreOffice and pay more attention to see what happens.

I was not aware of the settings in Tools - Options - Cal - Formula, now I will verify and make changes as needed

Many thanks for your time

[Zizi64]

=IF(F53=0,G52+E53,G52+F53)

The default formula separator character is the ";" (semicolon) in the OpenOffice and LibreOffice. The "," (comma) character is the decimal separator in many languages (locales). And the AOO and LO are multilanguage softwares. Use the semicolon. (Maybe that is not the root of your problen, but it is better to use the office suite in the regular way.)

[Oskar4U]

Thanks but using the semicolon I get ERROR, so I went back to comma
Much appreciated