IFERROR() for empty string?

[eyeonus]

I have an equation involving the concatenation of six cell formulas, each of which either outputs the cell contents or a blank string.

I want to output something else if the result of the concat is also an empty string, without having to use

if(
    concat(
        if([formula 1]<>"",[value 1],""),
        if([formula 2]<>"",[value 2],""),
        if([formula 3]<>"",[value 3],""),
        if([formula 4]<>"",[value 4],""),
        if([formula 5]<>"",[value 5],""),
        if([formula 6]<>"",[value 6],""),
    )<>"",
    concat(
        if([formula 1]<>"",[value 1],""),
        if([formula 2]<>"",[value 2],""),
        if([formula 3]<>"",[value 3],""),
        if([formula 4]<>"",[value 4],""),
        if([formula 5]<>"",[value 5],""),
        if([formula 6]<>"",[value 6],""),
    ),
    [otherwise value]
)

Is there something like IFERROR() that can be used on empty strings, so that I don’t have to have that giant block twice?

I would prefer to not have to use a holding cell for this, if possible.

[keme]

The CURRENT() function may be of use.

If that “otherwise value” is also text data, you can use something like:

=CONCAT(
    IF([formula 1]<>"";[value 1];"");
    IF([formula 2]<>"";[value 2];"");
    IF([formula 3]<>"";[value 3];"");
    IF([formula 4]<>"";[value 4];"");
    IF([formula 5]<>"";[value 5];"");
    IF([formula 6]<>"";[value 6];"");
    IF(CURRENT()="";"Otherwise value";"")
)

If you want to return a different data type or an error, you may need a more elaborate construct, which perhaps does not improve much over doing everything twice when you have just six entries. The construct will not grow with “block size”, so with larger sets there will be more to gain.

Please comment with some more detailed requirements if this does not help you solve your issue.

[eyeonus]

The otherwise value is also a string, so this works perfectly.

Thanks much!

[keme]

You are welcome!

If you will, click the gray tick cirkle to the left of the answer. This marks the issue as solved in the system, so other helpers see that your question does not need more attention.