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.
Choose could help but is only available for numerical values.
Thanks in advance!