excel 使用心得 结果不显示0 计算结果不显示0 =IF((A1*B1)=0,"",(A1*B1)) 求和结果不显示0 =IF(SUM(B3:H3)=0,"",SUM(B3:H3)) 引用结果不显示0 =IF(表1!A2=0,"",表1!A2) 判断 单元格判断 =IF(A1<0,"Yes","No"） 求和判断 =IF(SUM(A1:A10)<0,"Yes","No"）
