## [Solved] If then statements (now showing error 509)

### [Solved] If then statements (now showing error 509)

[Solved] Not resolved yet. May I have additional info.
I am running out of time and can't figure things out.

Can multiple if then statements be used? What is the syntax for office?
If C3 = 2848 then M3 = 2
If C3 = 1685 then M3 = 1
If c3 = 3488 them M3 = 1

I also could use help with
If M3 = 2 then p3 = L3*2

Thank you so much.
Last edited by lhentz on Fri Feb 15, 2019 5:27 pm, edited 3 times in total.
OpenOffice 4.16
OS Windows 10
lhentz

Posts: 7
Joined: Mon Feb 11, 2019 6:46 pm

### Re: If then statements

Hello lhentz

Try with :

=IF(OR(C3=1685,C3=3488),1,IF(C3=2848,2,""))

=IF(M3=2;L3*2;"")
LibreOffice (fr_YT): 6.1.4.2 (26/12/2018)
OS : Windows 10.0
njhub

Posts: 30
Joined: Thu May 17, 2018 8:36 am
Location: Mayotte YT

### Re: If then statements

The first one makes sense to me but unfortunately I got an error 509 .

I forgot the second part of the last one
=IF(M3=2;L3*2;"") ADD if M3=1 then Q3=an empty cell
OpenOffice 4.16
OS Windows 10
lhentz

Posts: 7
Joined: Mon Feb 11, 2019 6:46 pm

### Re: If then statements

In OpenOffice, you must use semicolons to separate the parts of a function call
Code: Select all   Expand viewCollapse view
`=IF(OR(C3=1685;C3=3488);1;IF(C3=2848;2;""))`

I am not sure I understand your second request. Do you want
Code: Select all   Expand viewCollapse view
`=IF(M3=2;L3*2;"")`

in P3 and a different formula in Q3?
Windows 10 and Linux Mint, since 2017
FJCC
Moderator

Posts: 7053
Joined: Sat Nov 08, 2008 8:08 pm

### Re: If then statements

Please note that, for Q3, it's impossible to have it literally return a blank entry. You can make the entry look blank, but that's the closest Calc is capable of.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer

Posts: 4867
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

### Re: If then statements

lhentz wrote:I am running out of time and can't figure things out.

Search Help with functions and you will get all the assistance you need including information on the Function Wizard. It's also covered in the Calc Guide.

You will find much useful information in the User Guides, the Writer, Base and Calc Tutorials and the AOO Frequently Asked Questions. May I suggest you bookmark the pages.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer

Posts: 6440
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK