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

Discuss the spreadsheet application

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

Postby John175 » Thu Jul 23, 2020 7:37 am

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?
Last edited by MrProgrammer on Thu Jul 30, 2020 5:16 pm, edited 3 times in total.
Reason: Changed subject, was: If calc err 509; Tagged ✓ [Solved]
open office4 ver 4.1.7 Windows 10
Posts: 1
Joined: Thu Jul 23, 2020 7:09 am

Re: If calc err 509

Postby MrProgrammer » Thu Jul 23, 2020 8:07 am

Hi, and welcome to the forum.

John175 wrote: In cell C3 I enter =if(A3>0,A3,0). I get err 509.
OpenOffice Help wrote:
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
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
Posts: 3904
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Return to Calc

Who is online

Users browsing this forum: Google [Bot], mike.stirton and 11 guests