为什么我不能在这个公式中插入“”以取消“假”文本？

Question

这就是公式：

=arrayformula(if(row(A:A)=1; "Time"; if(len(A:A); IF(C:C=F:F;
    IF(QUOTIENT(F:F*(D:D/60);24)<1;
        ROUNDUP(MOD(F:F*(D:D/60);24))& IF(ROUNDUP(MOD(F:F*(D:D/60);24)>1);" ore"; " ora")&" circa";
        QUOTIENT(F:F*(D:D/60);24) & IF(QUOTIENT(F:F*(D:D/60);24)>1;" giorni";" giorno") & IF(ROUNDUP(MOD(F:F*(D:D/60);24)=0);""; " e "&ROUNDUP(MOD(F:F*(D:D/60);24))&" ore"&" circa"));
    IF(QUOTIENT(F:F*(D:D/60);24)<1;
        ROUNDUP(MOD(F:F*(D:D/60);24))&IF(ROUNDUP(MOD(F:F*(D:D/60);24)>1);" ore"; " ora")&" circa"&"<br>su "&ROUNDUP(MOD(C:C*(D:D/60);24))&" ore"&" circa";
        QUOTIENT(F:F*(D:D/60);24)& IF(QUOTIENT(F:F*(D:D/60);24)>1;" giorni";" giorno")&" e "& IF(ROUNDUP(MOD(F:F*(D:D/60);24)=0);""; ROUNDUP(MOD(F:F*(D:D/60);24))&IF(ROUNDUP(MOD(F:F*(D:D/60);24)>1);" ore"; " ora")&" circa")&"<br>su "&QUOTIENT(C:C*(D:D/60);24)& IF(QUOTIENT(C:C*(D:D/60);24)>1;" giorni";" giorno")& IF(ROUNDUP(MOD(C:C*(D:D/60);24)=0);""; " e "&ROUNDUP(MOD(C:C*(D:D/60);24))&" ore"&" circa"))))))

这里有一个示例表，其中包含了正在执行的公式：

https://docs.google.com/spreadsheets/d/1zP2i-Tx3QKEZjU4SbiyJg4xWwtTZt9seDDzSrRxlOjg/

为什么我不能在公式的末尾插入"FALSE“，以便在最后一行中删除包含内容的”FALSE“文本？

Answer 1

请尝试将最后六个结束括号替换为：

))),"")))