Ask Your Question

IF statement with 2 Then_Value

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

this post is marked as community wiki

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 flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-11-22 21:05:58 +0200

Jim K gravatar image

updated 2017-11-22 21:13:06 +0200

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.


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


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

edit flag offensive delete link more

answered 2017-11-21 23:26:22 +0200

librebel gravatar image

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.


edit flag offensive delete link more


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

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

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

librebel gravatar imagelibrebel ( 2017-11-24 01:52:59 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 1,050 times

Last updated: Nov 22 '17