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

Discuss the spreadsheet application

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

Postby lhentz » Tue Feb 12, 2019 7:32 pm

[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

Postby njhub » Tue Feb 12, 2019 7:46 pm

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

Postby lhentz » Tue Feb 12, 2019 8:52 pm

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

Postby FJCC » Tue Feb 12, 2019 9:47 pm

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
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7065
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: If then statements

Postby RusselB » Tue Feb 12, 2019 11:14 pm

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: 4875
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: If then statements

Postby John_Ha » Wed Feb 13, 2019 1:04 am

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: 6482
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Calc

Who is online

Users browsing this forum: No registered users and 22 guests