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)
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.
And that’s not two Then_Values but one Then_Value and one Else_Value …
… the Else_Value being of course interpreted as “Else Then…”
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.