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

[lhentz]

[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.

[njhub]

Hello lhentz

Try with :

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

=IF(M3=2;L3*2;"")

[lhentz]

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

[FJCC]

In OpenOffice, you must use semicolons to separate the parts of a function call

Code: Select all

=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

=IF(M3=2;L3*2;"")

in P3 and a different formula in Q3?

[RusselB]

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.

[John_Ha]

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.