[Solved] IF() function generates Err:509 message

[MrProgrammer]

Hi.
I open a new spreadsheet and in Cell A3 i enter the number 25. In cell C3 I enter =if(A3>0,A3,0). I get err 509.
I have looked at the help and It seems to me the syntax is correct, but I just do not understand. What am I missing?
Thanks.
John

[MrProgrammer]

Hi, and welcome to the forum.

In cell C3 I enter =if(A3>0,A3,0). I get err 509.

IF: Returns one of two values, depending on a test condition.
Syntax: IF(Test; ThenValue; OtherwiseValue)

Use a semicolon in OpenOffice Calc formulas. You could also use =MAX(A3;0) in C3.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know