Ask Your Question

# IF statement with 2 Then_Value

asked 2017-11-21 22:06:57 +0200

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I'm trying to implement an IF statement including 2 Then_Value. At once, I would be grateful if you could confirm that is it possible. If so, I'll share my broken formulas.

More information from @sachalex

Thanks for your reply. I've not been clear, do you think it is possible to implement 2 Then_Value (when condition TRUE) and 1 Otherwise_Value (when condition is FALSE). For example : IF(Test; Then_Value1 & Then_Value2; Otherwise_Value)

edit retag close merge delete

## 2 Answers

Sort by » oldest newest most voted

What do you hope to accomplish by using two values for the "then" clause? A cell displays a single result. Here is an example that concatenates two values into a single string.

=IF(A1<>"";A1&A2;"Empty")

Here is an example that finds the result of two expressions.

=IF(A1>0;AND(1;1);0)

Or perhaps you want to have more than one result. Array formulas can do this, filling more than one cell from a single formula.

more

The IF-function in LO Calc accepts two Then_Values, the first one is for when the test condition yields TRUE, and the second one is for when the test condition yields FALSE.

more

## Comments

And that's not two Then_Values but one Then_Value and one Else_Value ...

( 2017-11-24 01:17:58 +0200 )edit

... the Else_Value being of course interpreted as "Else Then..."

( 2017-11-24 01:52:59 +0200 )edit

## Stats

Asked: 2017-11-21 22:06:57 +0200

Seen: 1,050 times

Last updated: Nov 22 '17