Apache OpenOffice Community Forum

Posted: **Wed Jan 02, 2013 1:45 pm**

Hey, just entered this forum searching for a strange case:
The IF functions always return #NAME

Code: =if (C2 = 3 ;"OK";"FAIL") I tried several variations without sucess.
I guess there is something with my setup:

LibreOffice 3.5.4.2 Bygg-ID: 350m1(Build:2) On top of Ubuntu 12.04 with Norwegian character set and keyboard.

: Screendump to show the situation.; screendump calc.png (7.9 KiB) Viewed 7532 times

Any idea, anyone?
Thanks
Reidar

Posted: **Wed Jan 02, 2013 2:08 pm**

Bit of a stab in the dark, but in my version the delimiter inside the formula would need to be , not ;
Give it a try and let us know if that worked?

Posted: **Wed Jan 02, 2013 2:20 pm**

If the language is set to Norwegian, shouldn't the function name be entered in Norwegian? That is, instead of IF() use (if I can rely on Google translate) HVIS().

Posted: **Wed Jan 02, 2013 2:21 pm**

It worked for me on AOO 3.4.1 using ; - try IF instead of if.

Posted: **Wed Jan 02, 2013 2:41 pm**

Looking at the screenshot, do you have a space between if and (?
If you do, delete it.

Posted: **Wed Jan 02, 2013 2:53 pm**

FJCC wrote:If the language is set to Norwegian, shouldn't the function name be entered in Norwegian? That is, instead of IF() use (if I can rely on Google translate) HVIS().

Thanks! You saved me form fooling around!

Thanks again

Reidar

Apache OpenOffice Community Forum

[Solved] LibreOffice Calc IF function not working?

[Solved] LibreOffice Calc IF function not working?

Re: LibreOffice Calc IF function not working?

Re: LibreOffice Calc IF function not working?

Re: LibreOffice Calc IF function not working?

Re: LibreOffice Calc IF function not working?

Re: LibreOffice Calc IF function not working?