=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的和,否則返回空值

添加新評論

暱稱
郵箱
網站