excel两个单元格相乘,当其中一个单元格为空时如何设置运算结果等于另一单元格数值
再加一个条件:当两个单元格都为空时,结果也为空。
=IF(AND(A1="",B1=""),"",IF(A1="",B1,IF(B1="",A1,A1*B1)))
=IF(AND(A1="",B1=""),"",(A1+(A1=""))*(B1+(B1="")))
数据在A列和B列,=IF(COUNT(A1:B1)=1,SUM(A1:B1),A1*B1)
热门标签:
=IF(AND(A1="",B1=""),"",IF(A1="",B1,IF(B1="",A1,A1*B1)))
=IF(AND(A1="",B1=""),"",(A1+(A1=""))*(B1+(B1="")))
数据在A列和B列,=IF(COUNT(A1:B1)=1,SUM(A1:B1),A1*B1)