Ask Your Question

IF not working in Calc [closed]

asked 2014-02-25 01:04:56 +0200

ScottyDM gravatar image

updated 2020-08-18 23:32:15 +0200

Alex Kemp gravatar image


I'm using v4.1.4.2 for Mac. I would upgrade, but the only mirror the downloader keeps sending me to is offline (a different issue).

The IF statement no longer seems to work in Calc. The built-in help tells me the syntax is:

IF(Test; ThenValue; OtherwiseValue)

And then gives the example:

=IF(A1>5;100;"too small")

My actual line of code is:


I see it too. Those are supposed to be semicolons, not commas. Except I put semicolons in but the program automagically changes them to commas. I assume this is the reason for the failure.

What is shown is either "TRUE" or "FALSE", not the numeric value in Y2 or a zero.

This used to work, so not sure what's happening. Is this a recently introduced bug? Do I have a corrupted config? Do I have a corrupted install of LibreOffice? Something else? How do I get this to not change semicolons to commas?



edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 11:46:53.108608

1 Answer

Sort by » oldest newest most voted

answered 2014-02-25 01:28:51 +0200

m.a.riosv gravatar image

Hi @Scotty, I think it is only a format issue, usually Ctrl+M clear the TRUE/FALSE format.

edit flag offensive delete link more


Thanks. Ctrl+M works. My next question is: How did this get changed? Other than debugging IF statements this seems a pretty worthless feature. Also, is it a bug in the help file that shows I need a semicolon? Happier, but still perplexed.

ScottyDM gravatar imageScottyDM ( 2014-02-25 01:50:17 +0200 )edit

Question Tools

1 follower


Asked: 2014-02-25 01:04:56 +0200

Seen: 1,515 times

Last updated: Feb 25 '14