excel中如果a1=0,a2=0,则a3=“”,否则=a1+a2,怎么设置公式

2024-11-29 14:47:15
推荐回答(3个)
回答1:

A3=IF(AND(A1=0,A2=0),"",A1+A2)

回答2:

=if(and(a1=0,a2=0),"",a1+a2)

回答3:

fgxdfhtjhdg