Ask Your Question
0

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
0

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.

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

edit flag offensive delete link more
0

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.

See: https://help.libreoffice.org/Calc/Log...

edit flag offensive delete link more

Comments

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

Stats

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

Seen: 448 times

Last updated: Nov 22 '17