Hi everybody,
is there an easy way to have a “case” or a “switch” function in LibreOffice Calc?
It could work this way:
CASE [ expression ]
WHEN condition_1 THEN result_1
WHEN condition_2 THEN result_2
...
WHEN condition_n THEN result_n
ELSE result
END
I am currently struggling with nested IFs: IF(condition_1;result_condition1_yes;IF(condition_2;result_condition2_yes;IF(condition_3; ... )
This kind of nested formula is possible but extremely difficult to read, also because there are no colors or other formatting in the formula bar that could help differentiate the several parts of the expression.
The function Choose
could help but is only available for numerical values.
Any suggestions?
Thanks in advance!