Ubuntu

Open Office Query

Asked by Ian Brownlie

 Could anybody please show me the correct syntax for an "IF, AND " statement. I have only ever used excel and am still coming to terms with OO.
      Thanks, Ian

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu Edit question
Assignee:
No assignee Edit question
Solved by:
Ralph Janke
Solved:
Last query:
Last reply:
Revision history for this message
Ralph Janke (txwikinger) said : 		#1

Thanks or the question.

The syntax for IF is as follows:

IF(test; then_value; otherwise_value)

The syntax for AND is as follows:

AND(Logical_value1; Logical_value2; ....)

Combine as an Example:

=IF(AND(B2=1;B3=2);1;0)

Hope this helps!

Revision history for this message
Best Ralph Janke (txwikinger) said : 		#2

Btw. you can also click on the f(x) button and fill out the formula interactively with the gui.

Hope this helps.

Revision history for this message
Ian Brownlie (ibrownlie) said : 		#3

Thanks Ralph Janke, that solved my question.