多IF语句问题

Question

我试图在谷歌工作表上设置双重条件，使单元格不显示空输出的错误。

=IFS( K8="", "",K8="COMMANDE LIVRER", "",QUERY('A PAYER'!G9:K,"Select J,K WHERE G='A8'",1))

第一个条件是检查单元K8是否为空以返回空；命令LIVRER"；。谢谢

Answer 1

try:

=IF((K8="")+(K8="COMMANDE LIVRER"),,
QUERY('A PAYER'!G9:K, "select J,K where G='A8'", 1))

Answer 2

如果K8不是NULL且不是"；命令LIVRER"；。

=if(K8="","",if(K8="COMMANDE LIVRER", "",QUERY('A PAYER'!G9:K,"Select J,K WHERE G='A8'",1)))