=IF(A3"",SUM(B$2:B2)-SUM(C$1:C1),"") 看不懂
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/13 07:18:31
![=IF(A3](/uploads/image/z/5536827-27-7.jpg?t=%3DIF%28A3%22%22%2CSUM%28B%242%3AB2%29-SUM%28C%241%3AC1%29%2C%22%22%29+%E7%9C%8B%E4%B8%8D%E6%87%82)
x)tp4VR pR1r2U
5u4~Y{MR>ZlȲ鲦g8|]O?y3jy:i{Ӿ ":O',{1F 1 ~c)
=IF(A3"",SUM(B$2:B2)-SUM(C$1:C1),"") 看不懂
=IF(A3"",SUM(B$2:B2)-SUM(C$1:C1),"") 看不懂
=IF(A3"",SUM(B$2:B2)-SUM(C$1:C1),"") 看不懂
如果A3不等于空值,返回B$2:B2的和减去C$1:C1的和,否则返回空值