[Solved] LibreOffice Calc IF function not working?

[reidnord]

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 7531 times

Any idea, anyone?
Thanks
Reidar

[Shenshen]

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?

[FJCC]

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().

[RoryOF]

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

[Shenshen]

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

[reidnord]

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