如果单元格A1=0,真值=B1&C1,如果单元格A1和B1同时=0，真值=C

更新时间2018-08-11 16:23:10

=if(and(A1=0,B1=0),"C",if(A1=0,B1&C1,""))