# Revision history [back]

### IF not working in Calc

Greetings:

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:

=IF(AC2<>0,$Y2,0)  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", as if the code was: 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? Thanks. Scotty ### IF not working in Calc Greetings: 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: =IF(AC2<>0,$Y2,0)


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", as if the code was: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?

Thanks.

Scotty

 3 retagged Alex Kemp 10514 ●14 ●42 ●42 http://etmg.altervista...

### IF not working in Calc

Greetings:

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:

=IF(AC2<>0,$Y2,0)  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? Thanks. Scotty  4 retagged Alex Kemp 10514 ●14 ●42 ●42 http://etmg.altervista... ### IF not working in Calc Greetings: 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: =IF(AC2<>0,$Y2,0)


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?

Thanks.

Scotty