Question

关于EXCEL公式,=IF(A6>=1,ROUND(ABS(SUMIF($A$5:$A6,">=1",$G$5:$G6)

Answer 1

=IF(A6>=1,ROUND(ABS(SUMIF($A$5:$A6,">=1",$G$5:$G6)+$L$5-SUMIF($A$5:$A6,">=1",$H$5:$H6)),2),"")

如果A6大于等于1,则计算,否则返回空.

计算时,对A5:A6大于等于1对应的G5:G6值求和,加上L5的值,再减去A5:A6大于等于1对应的H5:H6的和,并对这个值用ABS求绝对值,最后用ROUND保留两位小数.